<?xml version="1.0" encoding="utf-8"?>
<lzc:project name="ASTD Certifications Institute Portal" owner="dbo" user="jmuharsky" defaultnamespace="ASTD.CIPortal" namespaceprefix="astd" namespaceuri="http://schemas.astd.org/CIPortal" B="True" xmlns:lzc="http://schemas.icitadel.com/Lazarus/Compiled.xsd">
  <lzc:description>SQL Server 2000 Database for the ASTD Certifications Institute Portal</lzc:description>
  <lzc:datasource location="ASTDWeb-1" schema="CIPortalDB" user="CIPortalDBAccess" password="Password!" />
  <lzc:security />
  <lzc:objects>
    <lzc:object name="Settings" alias="Settings" filename="Settings" namespace="ASTD.CIPortal" friendly-name="Settings" logical-name="Settings" db-table="Settings">
      <lzc:description>Defines various application-level read/write settings.</lzc:description>
      <lzc:fields>
        <lzc:field name="Id" alias="id" autogenerate="True" type="Identity" friendly-name="Id" readonly="False" required="True" tableonly="False" logical-name="Id" dbname="Id" dbtype="Int">
          <lzc:indexes>
            <lzc:index name="PK_Settings" type="Primary" constraintname="PK_Settings_Id" cascade-delete="False" />
          </lzc:indexes>
        </lzc:field>
        <lzc:field name="Name" alias="name" autogenerate="False" type="Varchar" friendly-name="Name" readonly="False" required="True" size="50" tableonly="False" logical-name="Name" dbname="Name" dbtype="Varchar" />
        <lzc:field name="Value" alias="value" autogenerate="False" type="Varchar" friendly-name="Value" readonly="False" required="True" size="255" tableonly="False" logical-name="Value" dbname="Value" dbtype="Varchar" />
      </lzc:fields>
      <lzc:all-fields>
        <lzc:object-ref ref="Settings">
          <lzc:fields>
            <lzc:field name="Id" alias="id" autogenerate="True" type="Identity" friendly-name="Id" readonly="False" required="True" tableonly="False" logical-name="Id" dbname="Id" dbtype="Int">
              <lzc:indexes>
                <lzc:index name="PK_Settings" type="Primary" constraintname="PK_Settings_Id" cascade-delete="False" />
              </lzc:indexes>
            </lzc:field>
            <lzc:field name="Name" alias="name" autogenerate="False" type="Varchar" friendly-name="Name" readonly="False" required="True" size="50" tableonly="False" logical-name="Name" dbname="Name" dbtype="Varchar" />
            <lzc:field name="Value" alias="value" autogenerate="False" type="Varchar" friendly-name="Value" readonly="False" required="True" size="255" tableonly="False" logical-name="Value" dbname="Value" dbtype="Varchar" />
          </lzc:fields>
        </lzc:object-ref>
      </lzc:all-fields>
    </lzc:object>
    <lzc:object name="Customer" alias="Customer" filename="Customer" namespace="ASTD.CIPortal" friendly-name="Customer" logical-name="Customer" db-table="Customer">
      <lzc:fields>
        <lzc:field name="Id" alias="id" autogenerate="True" type="Identity" friendly-name="Id" readonly="False" required="True" tableonly="False" logical-name="Id" dbname="Id" dbtype="Int">
          <lzc:indexes>
            <lzc:index name="PK_Customer" type="Primary" constraintname="PK_Customer_Id" cascade-delete="False" />
          </lzc:indexes>
        </lzc:field>
        <lzc:field name="NameFirst" alias="namefirst" autogenerate="False" type="Varchar" friendly-name="NameFirst" readonly="False" required="False" size="50" tableonly="False" logical-name="NameFirst" dbname="NameFirst" dbtype="Varchar">
          <lzc:description>First name of the customer.</lzc:description>
        </lzc:field>
        <lzc:field name="NameMiddle" alias="namemiddle" autogenerate="False" type="Varchar" friendly-name="NameMiddle" readonly="False" required="False" size="50" tableonly="False" logical-name="NameMiddle" dbname="NameMiddle" dbtype="Varchar">
          <lzc:description>Middle name (or initial) of the customer.</lzc:description>
        </lzc:field>
        <lzc:field name="NameLast" alias="namelast" autogenerate="False" type="Varchar" friendly-name="NameLast" readonly="False" required="False" size="50" tableonly="False" logical-name="NameLast" dbname="NameLast" dbtype="Varchar">
          <lzc:description>Last name of the customer.</lzc:description>
        </lzc:field>
        <lzc:field name="Suffix" alias="suffix" autogenerate="False" type="Varchar" friendly-name="Suffix" readonly="False" required="False" size="10" tableonly="False" logical-name="Suffix" dbname="Suffix" dbtype="Varchar">
          <lzc:description>Specifies the customer's name suffix (Jr., Sr., etc.).</lzc:description>
        </lzc:field>
        <lzc:field name="Prefix" alias="prefix" autogenerate="False" type="Varchar" friendly-name="Prefix" readonly="False" required="False" size="10" tableonly="False" logical-name="Prefix" dbname="Prefix" dbtype="Varchar">
          <lzc:description>Specifies the customer's name prefix or title (Mr., Mrs., etc.)</lzc:description>
        </lzc:field>
        <lzc:field name="Industry" alias="industry" autogenerate="False" type="Int" friendly-name="Industry" readonly="False" required="False" tableonly="False" logical-name="Industry" dbname="IndustryId" dbtype="Int">
          <lzc:description>Specifies the industry that best describes where the customer conducts his/her work.</lzc:description>
          <lzc:indexes>
            <lzc:index name="IDX_Customer_Industry" alias="industry" accessor="Industry" object="PicklistItem" type="Foreign" constraintname="FK_Customer_Industry" cascade-delete="False" />
          </lzc:indexes>
        </lzc:field>
        <lzc:field name="OrganizationType" alias="organizationtype" autogenerate="False" type="Int" friendly-name="OrganizationType" readonly="False" required="False" tableonly="False" logical-name="OrganizationType" dbname="OrganizationTypeId" dbtype="Int">
          <lzc:indexes>
            <lzc:index name="IDX_Customer_OrganizationType" alias="organizationtype" accessor="OrganizationType" object="PicklistItem" type="Foreign" constraintname="FK_Customer_OrganizationType" cascade-delete="False" />
          </lzc:indexes>
        </lzc:field>
        <lzc:field name="AreaOfExpertise" alias="areaofexpertise" autogenerate="False" type="Int" friendly-name="AreaOfExpertise" readonly="False" required="False" tableonly="False" logical-name="AreaOfExpertise" dbname="AreaOfExpertiseId" dbtype="Int">
          <lzc:description>This specifies the Area of Expertise for the CPLP Work Product submission.</lzc:description>
          <lzc:indexes>
            <lzc:index name="IDX_Customer_AreaOfExpertise" alias="areaofexpertise" accessor="AreaOfExpertise" object="PicklistItem" type="Foreign" constraintname="FK_Customer_AreaOfExpertise" cascade-delete="False" />
          </lzc:indexes>
        </lzc:field>
        <lzc:field name="PrimaryAreaOfResponsibility" alias="primaryareaofresponsibility" autogenerate="False" type="Int" friendly-name="PrimaryAreaOfResponsibility" readonly="False" required="False" tableonly="False" logical-name="PrimaryAreaOfResponsibility" dbname="PrimaryAreaOfResponsibilityId" dbtype="Int">
          <lzc:indexes>
            <lzc:index name="IDX_Customer_PrimaryAreaOfResponsibility" alias="primaryareaofresponsibility" accessor="PrimaryAreaOfResponsibility" object="PicklistItem" type="Foreign" constraintname="FK_Customer_PrimaryAreaOfResponsibility" cascade-delete="False" />
          </lzc:indexes>
        </lzc:field>
        <lzc:field name="Gender" alias="gender" autogenerate="False" type="Varchar" friendly-name="Gender" readonly="False" required="False" size="1" tableonly="False" logical-name="Gender" dbname="Gender" dbtype="Varchar" />
        <lzc:field name="Ethnicity" alias="ethnicity" autogenerate="False" type="Int" friendly-name="Ethnicity" readonly="False" required="False" tableonly="False" logical-name="Ethnicity" dbname="EthnicityId" dbtype="Int">
          <lzc:indexes>
            <lzc:index name="IDX_Customer_Ethnicity" alias="ethnicity" accessor="Ethnicity" object="PicklistItem" type="Foreign" constraintname="FK_Customer_Ethnicity" cascade-delete="False" />
          </lzc:indexes>
        </lzc:field>
        <lzc:field name="SpanOfControl" alias="spanofcontrol" autogenerate="False" type="Int" friendly-name="SpanOfControl" readonly="False" required="False" tableonly="False" logical-name="SpanOfControl" dbname="SpanOfControlId" dbtype="Int">
          <lzc:indexes>
            <lzc:index name="IDX_Customer_SpanOfControl" alias="spanofcontrol" accessor="SpanOfControl" object="PicklistItem" type="Foreign" constraintname="FK_Customer_SpanOfControl" cascade-delete="False" />
          </lzc:indexes>
        </lzc:field>
        <lzc:field name="TIMSSCode" alias="timsscode" autogenerate="False" type="Varchar" friendly-name="TIMSSCode" readonly="False" required="False" size="8" tableonly="False" logical-name="TIMSSCode" dbname="TIMSSCode" dbtype="Varchar">
          <lzc:description>Customer ID from the TIMSS system.  This is used to bridge the TIMSS customers to the CIPortal customers.</lzc:description>
        </lzc:field>
        <lzc:field name="TestWindowId" alias="testwindowid" autogenerate="False" type="Int" friendly-name="TestWindowId" readonly="False" required="False" tableonly="False" logical-name="TestWindowId" dbname="TestWindowIdId" dbtype="Int">
          <lzc:indexes>
            <lzc:index name="IDX_Customer_TestWindowId" alias="testwindowid" accessor="TestWindowId" object="TestWindow" type="Foreign" constraintname="FK_Customer_TestWindowId" cascade-delete="False" />
          </lzc:indexes>
        </lzc:field>
        <lzc:field name="TestStatus" alias="teststatus" autogenerate="False" type="Int" default="1" friendly-name="TestStatus" readonly="False" required="True" tableonly="False" logical-name="TestStatus" dbname="TestStatusId" dbtype="Int">
          <lzc:indexes>
            <lzc:index name="IDX_Customer_TestStatus" alias="teststatus" accessor="TestStatus" object="TestStatus" type="Foreign" constraintname="FK_Customer_TestStatus" cascade-delete="False" />
          </lzc:indexes>
        </lzc:field>
        <lzc:field name="WorkSubmissionStatus" alias="worksubmissionstatus" autogenerate="False" type="Int" friendly-name="WorkSubmissionStatus" readonly="False" required="False" tableonly="False" logical-name="WorkSubmissionStatus" dbname="WorkSubmissionStatusId" dbtype="Int">
          <lzc:indexes>
            <lzc:index name="IDX_Customer_WorkSubmissionStatus" alias="worksubmissionstatus" accessor="WorkSubmissionStatus" object="TestStatus" type="Foreign" constraintname="FK_Customer_WorkSubmissionStatus" cascade-delete="False" />
          </lzc:indexes>
        </lzc:field>
        <lzc:field name="SpecialAccomodations" alias="specialaccomodations" autogenerate="False" type="Bit" default="0" friendly-name="SpecialAccomodations" readonly="False" required="True" tableonly="False" logical-name="SpecialAccomodations" dbname="SpecialAccomodations" dbtype="Bit">
          <lzc:description>This records whether or not the potential member has specified he/she needs special ADA accomodations.  ASTD Personnel will invistigate and provide the detailed accomodations required.</lzc:description>
        </lzc:field>
        <lzc:field name="YearsInWorkplace" alias="yearsinworkplace" autogenerate="False" type="Smallint" default="0" friendly-name="YearsInWorkplace" readonly="False" required="True" tableonly="False" logical-name="YearsInWorkplace" dbname="YearsInWorkplace" dbtype="Smallint">
          <lzc:description>This specifies the total number of years the potential member has been in the workplace, regardless of specific subject matter.</lzc:description>
        </lzc:field>
        <lzc:field name="OrganizationDescription" alias="organizationdescription" autogenerate="False" type="Text" friendly-name="OrganizationDescription" readonly="False" required="False" tableonly="False" logical-name="OrganizationDescription" dbname="OrganizationDescription" dbtype="Text" />
        <lzc:field name="Eligibility" alias="eligibility" autogenerate="False" type="Int" friendly-name="Eligibility" readonly="False" required="False" tableonly="False" logical-name="Eligibility" dbname="EligibilityId" dbtype="Int">
          <lzc:indexes>
            <lzc:index name="IDX_Customer_Eligibility" alias="eligibility" accessor="Eligibility" object="PicklistItem" type="Foreign" constraintname="FK_Customer_Eligibility" cascade-delete="False" />
          </lzc:indexes>
        </lzc:field>
        <lzc:field name="DegreeAttained" alias="degreeattained" autogenerate="False" type="Int" friendly-name="DegreeAttained" readonly="False" required="False" tableonly="False" logical-name="DegreeAttained" dbname="DegreeAttainedId" dbtype="Int">
          <lzc:description>The degree selected here should represent a field of study relevant to your degree.</lzc:description>
          <lzc:indexes>
            <lzc:index name="IDX_Customer_DegreeAttained" alias="degreeattained" accessor="DegreeAttained" object="PicklistItem" type="Foreign" constraintname="FK_Customer_DegreeAttained" cascade-delete="False" />
          </lzc:indexes>
        </lzc:field>
        <lzc:field name="YearGraduated" alias="yeargraduated" autogenerate="False" type="Smallint" friendly-name="YearGraduated" readonly="False" required="False" tableonly="False" logical-name="YearGraduated" dbname="YearGraduated" dbtype="Smallint">
          <lzc:description>This specifies the year graduated for their highest degree attained.</lzc:description>
        </lzc:field>
        <lzc:field name="CurrentStudent" alias="currentstudent" autogenerate="False" type="Bit" default="0" friendly-name="CurrentStudent" readonly="False" required="True" tableonly="False" logical-name="CurrentStudent" dbname="CurrentStudent" dbtype="Bit">
          <lzc:description>Specifies whether or not the customer is currently a student.</lzc:description>
        </lzc:field>
        <lzc:field name="HoldList" alias="holdlist" autogenerate="False" type="Int" friendly-name="HoldList" readonly="False" required="False" tableonly="False" logical-name="HoldList" dbname="HoldListId" dbtype="Int">
          <lzc:description>Specifies a reason that the administrator is holding the customer's account for later inclusion in the program.  Customers on the Hold List will not be exported to the test vendor.</lzc:description>
          <lzc:indexes>
            <lzc:index name="IDX_Customer_HoldList" alias="holdlist" accessor="HoldList" object="PicklistItem" type="Foreign" constraintname="FK_Customer_HoldList" cascade-delete="False" />
          </lzc:indexes>
        </lzc:field>
        <lzc:field name="CodeOfEthicsAcknowledgement" alias="codeofethicsacknowledgement" autogenerate="False" type="Bit" default="0" friendly-name="CodeOfEthicsAcknowledgement" readonly="False" required="True" tableonly="False" logical-name="CodeOfEthicsAcknowledgement" dbname="CodeOfEthicsAcknowledgement" dbtype="Bit" />
        <lzc:field name="ReleaseAgreement" alias="releaseagreement" autogenerate="False" type="Bit" default="0" friendly-name="ReleaseAgreement" readonly="False" required="True" tableonly="False" logical-name="ReleaseAgreement" dbname="ReleaseAgreement" dbtype="Bit" />
        <lzc:field name="FirstTimeTester" alias="firsttimetester" autogenerate="False" type="Bit" default="0" friendly-name="FirstTimeTester" readonly="False" required="True" tableonly="False" logical-name="FirstTimeTester" dbname="FirstTimeTester" dbtype="Bit">
          <lzc:description>Specifies whether or not the customer has taken a CPLP exam before.</lzc:description>
        </lzc:field>
        <lzc:field name="ValidatedByAdmin" alias="validatedbyadmin" autogenerate="False" type="Bit" default="0" friendly-name="ValidatedByAdmin" readonly="False" required="True" tableonly="False" logical-name="ValidatedByAdmin" dbname="ValidatedByAdmin" dbtype="Bit">
          <lzc:description>Indicates that the customer's account has been validated by an authorized administrator.  Customer accounts that have not been validated are not automatically exported.</lzc:description>
        </lzc:field>
        <lzc:field name="Exported" alias="exported" autogenerate="False" type="Bit" default="0" friendly-name="Exported" readonly="False" required="True" tableonly="False" logical-name="Exported" dbname="Exported" dbtype="Bit">
          <lzc:description>Specifies that the customer's information has been exported to the test vendor.</lzc:description>
        </lzc:field>
        <lzc:field name="TestVendorExportDate" alias="testvendorexportdate" autogenerate="False" type="DateTime" friendly-name="TestVendorExportDate" readonly="False" required="False" tableonly="False" logical-name="TestVendorExportDate" dbname="TestVendorExportDate" dbtype="DateTime">
          <lzc:description>Describes the date/time that the customer registration was exported to the Test Vendor.</lzc:description>
        </lzc:field>
        <lzc:field name="ExportOverride" alias="exportoverride" autogenerate="False" type="Bit" default="0" friendly-name="ExportOverride" readonly="False" required="True" tableonly="False" logical-name="ExportOverride" dbname="ExportOverride" dbtype="Bit">
          <lzc:description>Specifies whether the customer's information was manually selected for export to the Test Vendor.</lzc:description>
        </lzc:field>
        <lzc:field name="Address1Line1" alias="address1line1" autogenerate="False" type="Varchar" friendly-name="Address1Line1" readonly="False" required="False" size="100" tableonly="False" logical-name="Address1Line1" dbname="Address1Line1" dbtype="Varchar" />
        <lzc:field name="Address1Line2" alias="address1line2" autogenerate="False" type="Varchar" friendly-name="Address1Line2" readonly="False" required="False" size="100" tableonly="False" logical-name="Address1Line2" dbname="Address1Line2" dbtype="Varchar" />
        <lzc:field name="Address1Line3" alias="address1line3" autogenerate="False" type="Varchar" friendly-name="Address1Line3" readonly="False" required="False" size="100" tableonly="False" logical-name="Address1Line3" dbname="Address1Line3" dbtype="Varchar" />
        <lzc:field name="Address1City" alias="address1city" autogenerate="False" type="Varchar" friendly-name="Address1City" readonly="False" required="False" size="50" tableonly="False" logical-name="Address1City" dbname="Address1City" dbtype="Varchar" />
        <lzc:field name="Address1State" alias="address1state" autogenerate="False" type="Int" friendly-name="Address1State" readonly="False" required="False" tableonly="False" logical-name="Address1State" dbname="Address1StateId" dbtype="Int">
          <lzc:indexes>
            <lzc:index name="IDX_Customer_Address1State" alias="address1state" accessor="Address1State" object="PicklistItem" type="Foreign" constraintname="FK_Customer_Address1State" cascade-delete="False" />
          </lzc:indexes>
        </lzc:field>
        <lzc:field name="Address1Country" alias="address1country" autogenerate="False" type="Int" friendly-name="Address1Country" readonly="False" required="False" tableonly="False" logical-name="Address1Country" dbname="Address1CountryId" dbtype="Int">
          <lzc:indexes>
            <lzc:index name="IDX_Customer_Address1Country" alias="address1country" accessor="Address1Country" object="PicklistItem" type="Foreign" constraintname="FK_Customer_Address1Country" cascade-delete="False" />
          </lzc:indexes>
        </lzc:field>
        <lzc:field name="Address1ZipCode" alias="address1zipcode" autogenerate="False" type="Varchar" friendly-name="Address1ZipCode" readonly="False" required="False" size="10" tableonly="False" logical-name="Address1ZipCode" dbname="Address1ZipCode" dbtype="Varchar" />
        <lzc:field name="Address2Line1" alias="address2line1" autogenerate="False" type="Varchar" friendly-name="Address2Line1" readonly="False" required="False" size="100" tableonly="False" logical-name="Address2Line1" dbname="Address2Line1" dbtype="Varchar" />
        <lzc:field name="Address2Line2" alias="address2line2" autogenerate="False" type="Varchar" friendly-name="Address2Line2" readonly="False" required="False" size="100" tableonly="False" logical-name="Address2Line2" dbname="Address2Line2" dbtype="Varchar" />
        <lzc:field name="Address2Line3" alias="address2line3" autogenerate="False" type="Varchar" friendly-name="Address2Line3" readonly="False" required="False" size="100" tableonly="False" logical-name="Address2Line3" dbname="Address2Line3" dbtype="Varchar" />
        <lzc:field name="Address2City" alias="address2city" autogenerate="False" type="Varchar" friendly-name="Address2City" readonly="False" required="False" size="50" tableonly="False" logical-name="Address2City" dbname="Address2City" dbtype="Varchar" />
        <lzc:field name="Address2State" alias="address2state" autogenerate="False" type="Int" friendly-name="Address2State" readonly="False" required="False" tableonly="False" logical-name="Address2State" dbname="Address2StateId" dbtype="Int">
          <lzc:indexes>
            <lzc:index name="IDX_Customer_Address2State" alias="address2state" accessor="Address2State" object="PicklistItem" type="Foreign" constraintname="FK_Customer_Address2State" cascade-delete="False" />
          </lzc:indexes>
        </lzc:field>
        <lzc:field name="Address2Country" alias="address2country" autogenerate="False" type="Int" friendly-name="Address2Country" readonly="False" required="False" tableonly="False" logical-name="Address2Country" dbname="Address2CountryId" dbtype="Int">
          <lzc:indexes>
            <lzc:index name="IDX_Customer_Address2Country" alias="address2country" accessor="Address2Country" object="PicklistItem" type="Foreign" constraintname="FK_Customer_Address2Country" cascade-delete="False" />
          </lzc:indexes>
        </lzc:field>
        <lzc:field name="Address2ZipCode" alias="address2zipcode" autogenerate="False" type="Varchar" friendly-name="Address2ZipCode" readonly="False" required="False" size="10" tableonly="False" logical-name="Address2ZipCode" dbname="Address2ZipCode" dbtype="Varchar" />
        <lzc:field name="HomePhone" alias="homephone" autogenerate="False" type="Varchar" friendly-name="HomePhone" readonly="False" required="False" size="20" tableonly="False" logical-name="HomePhone" dbname="HomePhone" dbtype="Varchar" />
        <lzc:field name="WorkPhone" alias="workphone" autogenerate="False" type="Varchar" friendly-name="WorkPhone" readonly="False" required="False" size="20" tableonly="False" logical-name="WorkPhone" dbname="WorkPhone" dbtype="Varchar" />
        <lzc:field name="FaxNumber" alias="faxnumber" autogenerate="False" type="Varchar" friendly-name="FaxNumber" readonly="False" required="False" size="20" tableonly="False" logical-name="FaxNumber" dbname="FaxNumber" dbtype="Varchar" />
        <lzc:field name="Email" alias="email" autogenerate="False" type="Varchar" friendly-name="Email" readonly="False" required="False" size="255" tableonly="False" logical-name="Email" dbname="Email" dbtype="Varchar" />
      </lzc:fields>
      <lzc:collections>
        <lzc:collection name="AreasOfExpertise" alias="areasofexpertise" binding-object="CustomerExpertise" binding-field="CustomerId" object="PicklistItem" filename="PicklistItem" />
        <lzc:collection name="Accomodations" alias="accomodations" binding-object="CustomerAccomodation" binding-field="CustomerId" object="PicklistItem" filename="PicklistItem" />
        <lzc:collection name="EmploymentHistory" alias="employmenthistory" binding-object="Employer" binding-field="CustomerId" object="Employer" filename="Employer" />
        <lzc:collection name="EducationHistory" alias="educationhistory" binding-object="Institution" binding-field="CustomerId" object="Institution" filename="Institution" />
        <lzc:collection name="References" alias="references" binding-object="Reference" binding-field="CustomerId" object="Reference" filename="Reference" />
      </lzc:collections>
      <lzc:all-fields>
        <lzc:object-ref ref="Customer">
          <lzc:fields>
            <lzc:field name="Id" alias="id" autogenerate="True" type="Identity" friendly-name="Id" readonly="False" required="True" tableonly="False" logical-name="Id" dbname="Id" dbtype="Int">
              <lzc:indexes>
                <lzc:index name="PK_Customer" type="Primary" constraintname="PK_Customer_Id" cascade-delete="False" />
              </lzc:indexes>
            </lzc:field>
            <lzc:field name="NameFirst" alias="namefirst" autogenerate="False" type="Varchar" friendly-name="NameFirst" readonly="False" required="False" size="50" tableonly="False" logical-name="NameFirst" dbname="NameFirst" dbtype="Varchar">
              <lzc:description>First name of the customer.</lzc:description>
            </lzc:field>
            <lzc:field name="NameMiddle" alias="namemiddle" autogenerate="False" type="Varchar" friendly-name="NameMiddle" readonly="False" required="False" size="50" tableonly="False" logical-name="NameMiddle" dbname="NameMiddle" dbtype="Varchar">
              <lzc:description>Middle name (or initial) of the customer.</lzc:description>
            </lzc:field>
            <lzc:field name="NameLast" alias="namelast" autogenerate="False" type="Varchar" friendly-name="NameLast" readonly="False" required="False" size="50" tableonly="False" logical-name="NameLast" dbname="NameLast" dbtype="Varchar">
              <lzc:description>Last name of the customer.</lzc:description>
            </lzc:field>
            <lzc:field name="Suffix" alias="suffix" autogenerate="False" type="Varchar" friendly-name="Suffix" readonly="False" required="False" size="10" tableonly="False" logical-name="Suffix" dbname="Suffix" dbtype="Varchar">
              <lzc:description>Specifies the customer's name suffix (Jr., Sr., etc.).</lzc:description>
            </lzc:field>
            <lzc:field name="Prefix" alias="prefix" autogenerate="False" type="Varchar" friendly-name="Prefix" readonly="False" required="False" size="10" tableonly="False" logical-name="Prefix" dbname="Prefix" dbtype="Varchar">
              <lzc:description>Specifies the customer's name prefix or title (Mr., Mrs., etc.)</lzc:description>
            </lzc:field>
            <lzc:field name="Industry" alias="industry" autogenerate="False" type="Int" friendly-name="Industry" readonly="False" required="False" tableonly="False" logical-name="Industry" dbname="IndustryId" dbtype="Int">
              <lzc:description>Specifies the industry that best describes where the customer conducts his/her work.</lzc:description>
              <lzc:indexes>
                <lzc:index name="IDX_Customer_Industry" alias="industry" accessor="Industry" object="PicklistItem" type="Foreign" constraintname="FK_Customer_Industry" cascade-delete="False" />
              </lzc:indexes>
            </lzc:field>
            <lzc:field name="OrganizationType" alias="organizationtype" autogenerate="False" type="Int" friendly-name="OrganizationType" readonly="False" required="False" tableonly="False" logical-name="OrganizationType" dbname="OrganizationTypeId" dbtype="Int">
              <lzc:indexes>
                <lzc:index name="IDX_Customer_OrganizationType" alias="organizationtype" accessor="OrganizationType" object="PicklistItem" type="Foreign" constraintname="FK_Customer_OrganizationType" cascade-delete="False" />
              </lzc:indexes>
            </lzc:field>
            <lzc:field name="AreaOfExpertise" alias="areaofexpertise" autogenerate="False" type="Int" friendly-name="AreaOfExpertise" readonly="False" required="False" tableonly="False" logical-name="AreaOfExpertise" dbname="AreaOfExpertiseId" dbtype="Int">
              <lzc:description>This specifies the Area of Expertise for the CPLP Work Product submission.</lzc:description>
              <lzc:indexes>
                <lzc:index name="IDX_Customer_AreaOfExpertise" alias="areaofexpertise" accessor="AreaOfExpertise" object="PicklistItem" type="Foreign" constraintname="FK_Customer_AreaOfExpertise" cascade-delete="False" />
              </lzc:indexes>
            </lzc:field>
            <lzc:field name="PrimaryAreaOfResponsibility" alias="primaryareaofresponsibility" autogenerate="False" type="Int" friendly-name="PrimaryAreaOfResponsibility" readonly="False" required="False" tableonly="False" logical-name="PrimaryAreaOfResponsibility" dbname="PrimaryAreaOfResponsibilityId" dbtype="Int">
              <lzc:indexes>
                <lzc:index name="IDX_Customer_PrimaryAreaOfResponsibility" alias="primaryareaofresponsibility" accessor="PrimaryAreaOfResponsibility" object="PicklistItem" type="Foreign" constraintname="FK_Customer_PrimaryAreaOfResponsibility" cascade-delete="False" />
              </lzc:indexes>
            </lzc:field>
            <lzc:field name="Gender" alias="gender" autogenerate="False" type="Varchar" friendly-name="Gender" readonly="False" required="False" size="1" tableonly="False" logical-name="Gender" dbname="Gender" dbtype="Varchar" />
            <lzc:field name="Ethnicity" alias="ethnicity" autogenerate="False" type="Int" friendly-name="Ethnicity" readonly="False" required="False" tableonly="False" logical-name="Ethnicity" dbname="EthnicityId" dbtype="Int">
              <lzc:indexes>
                <lzc:index name="IDX_Customer_Ethnicity" alias="ethnicity" accessor="Ethnicity" object="PicklistItem" type="Foreign" constraintname="FK_Customer_Ethnicity" cascade-delete="False" />
              </lzc:indexes>
            </lzc:field>
            <lzc:field name="SpanOfControl" alias="spanofcontrol" autogenerate="False" type="Int" friendly-name="SpanOfControl" readonly="False" required="False" tableonly="False" logical-name="SpanOfControl" dbname="SpanOfControlId" dbtype="Int">
              <lzc:indexes>
                <lzc:index name="IDX_Customer_SpanOfControl" alias="spanofcontrol" accessor="SpanOfControl" object="PicklistItem" type="Foreign" constraintname="FK_Customer_SpanOfControl" cascade-delete="False" />
              </lzc:indexes>
            </lzc:field>
            <lzc:field name="TIMSSCode" alias="timsscode" autogenerate="False" type="Varchar" friendly-name="TIMSSCode" readonly="False" required="False" size="8" tableonly="False" logical-name="TIMSSCode" dbname="TIMSSCode" dbtype="Varchar">
              <lzc:description>Customer ID from the TIMSS system.  This is used to bridge the TIMSS customers to the CIPortal customers.</lzc:description>
            </lzc:field>
            <lzc:field name="TestWindowId" alias="testwindowid" autogenerate="False" type="Int" friendly-name="TestWindowId" readonly="False" required="False" tableonly="False" logical-name="TestWindowId" dbname="TestWindowIdId" dbtype="Int">
              <lzc:indexes>
                <lzc:index name="IDX_Customer_TestWindowId" alias="testwindowid" accessor="TestWindowId" object="TestWindow" type="Foreign" constraintname="FK_Customer_TestWindowId" cascade-delete="False" />
              </lzc:indexes>
            </lzc:field>
            <lzc:field name="TestStatus" alias="teststatus" autogenerate="False" type="Int" default="1" friendly-name="TestStatus" readonly="False" required="True" tableonly="False" logical-name="TestStatus" dbname="TestStatusId" dbtype="Int">
              <lzc:indexes>
                <lzc:index name="IDX_Customer_TestStatus" alias="teststatus" accessor="TestStatus" object="TestStatus" type="Foreign" constraintname="FK_Customer_TestStatus" cascade-delete="False" />
              </lzc:indexes>
            </lzc:field>
            <lzc:field name="WorkSubmissionStatus" alias="worksubmissionstatus" autogenerate="False" type="Int" friendly-name="WorkSubmissionStatus" readonly="False" required="False" tableonly="False" logical-name="WorkSubmissionStatus" dbname="WorkSubmissionStatusId" dbtype="Int">
              <lzc:indexes>
                <lzc:index name="IDX_Customer_WorkSubmissionStatus" alias="worksubmissionstatus" accessor="WorkSubmissionStatus" object="TestStatus" type="Foreign" constraintname="FK_Customer_WorkSubmissionStatus" cascade-delete="False" />
              </lzc:indexes>
            </lzc:field>
            <lzc:field name="SpecialAccomodations" alias="specialaccomodations" autogenerate="False" type="Bit" default="0" friendly-name="SpecialAccomodations" readonly="False" required="True" tableonly="False" logical-name="SpecialAccomodations" dbname="SpecialAccomodations" dbtype="Bit">
              <lzc:description>This records whether or not the potential member has specified he/she needs special ADA accomodations.  ASTD Personnel will invistigate and provide the detailed accomodations required.</lzc:description>
            </lzc:field>
            <lzc:field name="YearsInWorkplace" alias="yearsinworkplace" autogenerate="False" type="Smallint" default="0" friendly-name="YearsInWorkplace" readonly="False" required="True" tableonly="False" logical-name="YearsInWorkplace" dbname="YearsInWorkplace" dbtype="Smallint">
              <lzc:description>This specifies the total number of years the potential member has been in the workplace, regardless of specific subject matter.</lzc:description>
            </lzc:field>
            <lzc:field name="OrganizationDescription" alias="organizationdescription" autogenerate="False" type="Text" friendly-name="OrganizationDescription" readonly="False" required="False" tableonly="False" logical-name="OrganizationDescription" dbname="OrganizationDescription" dbtype="Text" />
            <lzc:field name="Eligibility" alias="eligibility" autogenerate="False" type="Int" friendly-name="Eligibility" readonly="False" required="False" tableonly="False" logical-name="Eligibility" dbname="EligibilityId" dbtype="Int">
              <lzc:indexes>
                <lzc:index name="IDX_Customer_Eligibility" alias="eligibility" accessor="Eligibility" object="PicklistItem" type="Foreign" constraintname="FK_Customer_Eligibility" cascade-delete="False" />
              </lzc:indexes>
            </lzc:field>
            <lzc:field name="DegreeAttained" alias="degreeattained" autogenerate="False" type="Int" friendly-name="DegreeAttained" readonly="False" required="False" tableonly="False" logical-name="DegreeAttained" dbname="DegreeAttainedId" dbtype="Int">
              <lzc:description>The degree selected here should represent a field of study relevant to your degree.</lzc:description>
              <lzc:indexes>
                <lzc:index name="IDX_Customer_DegreeAttained" alias="degreeattained" accessor="DegreeAttained" object="PicklistItem" type="Foreign" constraintname="FK_Customer_DegreeAttained" cascade-delete="False" />
              </lzc:indexes>
            </lzc:field>
            <lzc:field name="YearGraduated" alias="yeargraduated" autogenerate="False" type="Smallint" friendly-name="YearGraduated" readonly="False" required="False" tableonly="False" logical-name="YearGraduated" dbname="YearGraduated" dbtype="Smallint">
              <lzc:description>This specifies the year graduated for their highest degree attained.</lzc:description>
            </lzc:field>
            <lzc:field name="CurrentStudent" alias="currentstudent" autogenerate="False" type="Bit" default="0" friendly-name="CurrentStudent" readonly="False" required="True" tableonly="False" logical-name="CurrentStudent" dbname="CurrentStudent" dbtype="Bit">
              <lzc:description>Specifies whether or not the customer is currently a student.</lzc:description>
            </lzc:field>
            <lzc:field name="HoldList" alias="holdlist" autogenerate="False" type="Int" friendly-name="HoldList" readonly="False" required="False" tableonly="False" logical-name="HoldList" dbname="HoldListId" dbtype="Int">
              <lzc:description>Specifies a reason that the administrator is holding the customer's account for later inclusion in the program.  Customers on the Hold List will not be exported to the test vendor.</lzc:description>
              <lzc:indexes>
                <lzc:index name="IDX_Customer_HoldList" alias="holdlist" accessor="HoldList" object="PicklistItem" type="Foreign" constraintname="FK_Customer_HoldList" cascade-delete="False" />
              </lzc:indexes>
            </lzc:field>
            <lzc:field name="CodeOfEthicsAcknowledgement" alias="codeofethicsacknowledgement" autogenerate="False" type="Bit" default="0" friendly-name="CodeOfEthicsAcknowledgement" readonly="False" required="True" tableonly="False" logical-name="CodeOfEthicsAcknowledgement" dbname="CodeOfEthicsAcknowledgement" dbtype="Bit" />
            <lzc:field name="ReleaseAgreement" alias="releaseagreement" autogenerate="False" type="Bit" default="0" friendly-name="ReleaseAgreement" readonly="False" required="True" tableonly="False" logical-name="ReleaseAgreement" dbname="ReleaseAgreement" dbtype="Bit" />
            <lzc:field name="FirstTimeTester" alias="firsttimetester" autogenerate="False" type="Bit" default="0" friendly-name="FirstTimeTester" readonly="False" required="True" tableonly="False" logical-name="FirstTimeTester" dbname="FirstTimeTester" dbtype="Bit">
              <lzc:description>Specifies whether or not the customer has taken a CPLP exam before.</lzc:description>
            </lzc:field>
            <lzc:field name="ValidatedByAdmin" alias="validatedbyadmin" autogenerate="False" type="Bit" default="0" friendly-name="ValidatedByAdmin" readonly="False" required="True" tableonly="False" logical-name="ValidatedByAdmin" dbname="ValidatedByAdmin" dbtype="Bit">
              <lzc:description>Indicates that the customer's account has been validated by an authorized administrator.  Customer accounts that have not been validated are not automatically exported.</lzc:description>
            </lzc:field>
            <lzc:field name="Exported" alias="exported" autogenerate="False" type="Bit" default="0" friendly-name="Exported" readonly="False" required="True" tableonly="False" logical-name="Exported" dbname="Exported" dbtype="Bit">
              <lzc:description>Specifies that the customer's information has been exported to the test vendor.</lzc:description>
            </lzc:field>
            <lzc:field name="TestVendorExportDate" alias="testvendorexportdate" autogenerate="False" type="DateTime" friendly-name="TestVendorExportDate" readonly="False" required="False" tableonly="False" logical-name="TestVendorExportDate" dbname="TestVendorExportDate" dbtype="DateTime">
              <lzc:description>Describes the date/time that the customer registration was exported to the Test Vendor.</lzc:description>
            </lzc:field>
            <lzc:field name="ExportOverride" alias="exportoverride" autogenerate="False" type="Bit" default="0" friendly-name="ExportOverride" readonly="False" required="True" tableonly="False" logical-name="ExportOverride" dbname="ExportOverride" dbtype="Bit">
              <lzc:description>Specifies whether the customer's information was manually selected for export to the Test Vendor.</lzc:description>
            </lzc:field>
            <lzc:field name="Address1Line1" alias="address1line1" autogenerate="False" type="Varchar" friendly-name="Address1Line1" readonly="False" required="False" size="100" tableonly="False" logical-name="Address1Line1" dbname="Address1Line1" dbtype="Varchar" />
            <lzc:field name="Address1Line2" alias="address1line2" autogenerate="False" type="Varchar" friendly-name="Address1Line2" readonly="False" required="False" size="100" tableonly="False" logical-name="Address1Line2" dbname="Address1Line2" dbtype="Varchar" />
            <lzc:field name="Address1Line3" alias="address1line3" autogenerate="False" type="Varchar" friendly-name="Address1Line3" readonly="False" required="False" size="100" tableonly="False" logical-name="Address1Line3" dbname="Address1Line3" dbtype="Varchar" />
            <lzc:field name="Address1City" alias="address1city" autogenerate="False" type="Varchar" friendly-name="Address1City" readonly="False" required="False" size="50" tableonly="False" logical-name="Address1City" dbname="Address1City" dbtype="Varchar" />
            <lzc:field name="Address1State" alias="address1state" autogenerate="False" type="Int" friendly-name="Address1State" readonly="False" required="False" tableonly="False" logical-name="Address1State" dbname="Address1StateId" dbtype="Int">
              <lzc:indexes>
                <lzc:index name="IDX_Customer_Address1State" alias="address1state" accessor="Address1State" object="PicklistItem" type="Foreign" constraintname="FK_Customer_Address1State" cascade-delete="False" />
              </lzc:indexes>
            </lzc:field>
            <lzc:field name="Address1Country" alias="address1country" autogenerate="False" type="Int" friendly-name="Address1Country" readonly="False" required="False" tableonly="False" logical-name="Address1Country" dbname="Address1CountryId" dbtype="Int">
              <lzc:indexes>
                <lzc:index name="IDX_Customer_Address1Country" alias="address1country" accessor="Address1Country" object="PicklistItem" type="Foreign" constraintname="FK_Customer_Address1Country" cascade-delete="False" />
              </lzc:indexes>
            </lzc:field>
            <lzc:field name="Address1ZipCode" alias="address1zipcode" autogenerate="False" type="Varchar" friendly-name="Address1ZipCode" readonly="False" required="False" size="10" tableonly="False" logical-name="Address1ZipCode" dbname="Address1ZipCode" dbtype="Varchar" />
            <lzc:field name="Address2Line1" alias="address2line1" autogenerate="False" type="Varchar" friendly-name="Address2Line1" readonly="False" required="False" size="100" tableonly="False" logical-name="Address2Line1" dbname="Address2Line1" dbtype="Varchar" />
            <lzc:field name="Address2Line2" alias="address2line2" autogenerate="False" type="Varchar" friendly-name="Address2Line2" readonly="False" required="False" size="100" tableonly="False" logical-name="Address2Line2" dbname="Address2Line2" dbtype="Varchar" />
            <lzc:field name="Address2Line3" alias="address2line3" autogenerate="False" type="Varchar" friendly-name="Address2Line3" readonly="False" required="False" size="100" tableonly="False" logical-name="Address2Line3" dbname="Address2Line3" dbtype="Varchar" />
            <lzc:field name="Address2City" alias="address2city" autogenerate="False" type="Varchar" friendly-name="Address2City" readonly="False" required="False" size="50" tableonly="False" logical-name="Address2City" dbname="Address2City" dbtype="Varchar" />
            <lzc:field name="Address2State" alias="address2state" autogenerate="False" type="Int" friendly-name="Address2State" readonly="False" required="False" tableonly="False" logical-name="Address2State" dbname="Address2StateId" dbtype="Int">
              <lzc:indexes>
                <lzc:index name="IDX_Customer_Address2State" alias="address2state" accessor="Address2State" object="PicklistItem" type="Foreign" constraintname="FK_Customer_Address2State" cascade-delete="False" />
              </lzc:indexes>
            </lzc:field>
            <lzc:field name="Address2Country" alias="address2country" autogenerate="False" type="Int" friendly-name="Address2Country" readonly="False" required="False" tableonly="False" logical-name="Address2Country" dbname="Address2CountryId" dbtype="Int">
              <lzc:indexes>
                <lzc:index name="IDX_Customer_Address2Country" alias="address2country" accessor="Address2Country" object="PicklistItem" type="Foreign" constraintname="FK_Customer_Address2Country" cascade-delete="False" />
              </lzc:indexes>
            </lzc:field>
            <lzc:field name="Address2ZipCode" alias="address2zipcode" autogenerate="False" type="Varchar" friendly-name="Address2ZipCode" readonly="False" required="False" size="10" tableonly="False" logical-name="Address2ZipCode" dbname="Address2ZipCode" dbtype="Varchar" />
            <lzc:field name="HomePhone" alias="homephone" autogenerate="False" type="Varchar" friendly-name="HomePhone" readonly="False" required="False" size="20" tableonly="False" logical-name="HomePhone" dbname="HomePhone" dbtype="Varchar" />
            <lzc:field name="WorkPhone" alias="workphone" autogenerate="False" type="Varchar" friendly-name="WorkPhone" readonly="False" required="False" size="20" tableonly="False" logical-name="WorkPhone" dbname="WorkPhone" dbtype="Varchar" />
            <lzc:field name="FaxNumber" alias="faxnumber" autogenerate="False" type="Varchar" friendly-name="FaxNumber" readonly="False" required="False" size="20" tableonly="False" logical-name="FaxNumber" dbname="FaxNumber" dbtype="Varchar" />
            <lzc:field name="Email" alias="email" autogenerate="False" type="Varchar" friendly-name="Email" readonly="False" required="False" size="255" tableonly="False" logical-name="Email" dbname="Email" dbtype="Varchar" />
          </lzc:fields>
        </lzc:object-ref>
      </lzc:all-fields>
    </lzc:object>
    <lzc:object name="Picklist" alias="Picklist" filename="Picklist" namespace="ASTD.CIPortal" friendly-name="Picklist" logical-name="Picklist" db-table="Picklist">
      <lzc:fields>
        <lzc:field name="Id" alias="id" autogenerate="True" type="Identity" friendly-name="Id" readonly="False" required="True" tableonly="False" logical-name="Id" dbname="Id" dbtype="Int">
          <lzc:indexes>
            <lzc:index name="PK_Picklist" type="Primary" constraintname="PK_Picklist_Id" cascade-delete="False" />
          </lzc:indexes>
        </lzc:field>
        <lzc:field name="Title" alias="title" autogenerate="False" type="Varchar" friendly-name="Title" readonly="False" required="True" size="50" tableonly="False" logical-name="Title" dbname="Title" dbtype="Varchar" />
      </lzc:fields>
      <lzc:collections>
        <lzc:collection name="Items" alias="items" binding-object="PicklistItem" binding-field="Picklist" object="PicklistItem" filename="PicklistItem" />
      </lzc:collections>
      <lzc:all-fields>
        <lzc:object-ref ref="Picklist">
          <lzc:fields>
            <lzc:field name="Id" alias="id" autogenerate="True" type="Identity" friendly-name="Id" readonly="False" required="True" tableonly="False" logical-name="Id" dbname="Id" dbtype="Int">
              <lzc:indexes>
                <lzc:index name="PK_Picklist" type="Primary" constraintname="PK_Picklist_Id" cascade-delete="False" />
              </lzc:indexes>
            </lzc:field>
            <lzc:field name="Title" alias="title" autogenerate="False" type="Varchar" friendly-name="Title" readonly="False" required="True" size="50" tableonly="False" logical-name="Title" dbname="Title" dbtype="Varchar" />
          </lzc:fields>
        </lzc:object-ref>
      </lzc:all-fields>
    </lzc:object>
    <lzc:object name="PicklistItem" alias="PicklistItem" filename="PicklistItem" namespace="ASTD.CIPortal" friendly-name="PicklistItem" logical-name="PicklistItem" db-table="PicklistItem" title-field="Title">
      <lzc:description>Defines an item in a picklist.</lzc:description>
      <lzc:fields>
        <lzc:field name="Id" alias="id" autogenerate="True" type="Identity" friendly-name="Id" readonly="False" required="True" tableonly="False" logical-name="Id" dbname="Id" dbtype="Int">
          <lzc:indexes>
            <lzc:index name="PK_PicklistItem" type="Primary" constraintname="PK_PicklistItem_Id" cascade-delete="False" />
          </lzc:indexes>
        </lzc:field>
        <lzc:field name="Picklist" alias="picklist" autogenerate="False" type="Int" friendly-name="Picklist" readonly="False" required="True" tableonly="False" logical-name="Picklist" dbname="PicklistId" dbtype="Int">
          <lzc:indexes>
            <lzc:index name="IDX_PicklistItem_Picklist" alias="picklist" accessor="Picklist" object="Picklist" type="Foreign" constraintname="FK_PicklistItem_Picklist" cascade-delete="False" />
          </lzc:indexes>
        </lzc:field>
        <lzc:field name="Code" alias="code" autogenerate="False" type="Varchar" friendly-name="Code" readonly="False" required="False" size="2" tableonly="False" logical-name="Code" dbname="Code" dbtype="Varchar" />
        <lzc:field name="Title" alias="title" autogenerate="False" type="Varchar" friendly-name="Title" readonly="False" required="True" size="255" tableonly="False" logical-name="Title" dbname="Title" dbtype="Varchar" />
        <lzc:field name="Active" alias="active" autogenerate="False" type="Bit" default="1" friendly-name="Active" readonly="False" required="True" tableonly="False" logical-name="Active" dbname="Active" dbtype="Bit" />
      </lzc:fields>
      <lzc:all-fields>
        <lzc:object-ref ref="PicklistItem">
          <lzc:fields>
            <lzc:field name="Id" alias="id" autogenerate="True" type="Identity" friendly-name="Id" readonly="False" required="True" tableonly="False" logical-name="Id" dbname="Id" dbtype="Int">
              <lzc:indexes>
                <lzc:index name="PK_PicklistItem" type="Primary" constraintname="PK_PicklistItem_Id" cascade-delete="False" />
              </lzc:indexes>
            </lzc:field>
            <lzc:field name="Picklist" alias="picklist" autogenerate="False" type="Int" friendly-name="Picklist" readonly="False" required="True" tableonly="False" logical-name="Picklist" dbname="PicklistId" dbtype="Int">
              <lzc:indexes>
                <lzc:index name="IDX_PicklistItem_Picklist" alias="picklist" accessor="Picklist" object="Picklist" type="Foreign" constraintname="FK_PicklistItem_Picklist" cascade-delete="False" />
              </lzc:indexes>
            </lzc:field>
            <lzc:field name="Code" alias="code" autogenerate="False" type="Varchar" friendly-name="Code" readonly="False" required="False" size="2" tableonly="False" logical-name="Code" dbname="Code" dbtype="Varchar" />
            <lzc:field name="Title" alias="title" autogenerate="False" type="Varchar" friendly-name="Title" readonly="False" required="True" size="255" tableonly="False" logical-name="Title" dbname="Title" dbtype="Varchar" />
            <lzc:field name="Active" alias="active" autogenerate="False" type="Bit" default="1" friendly-name="Active" readonly="False" required="True" tableonly="False" logical-name="Active" dbname="Active" dbtype="Bit" />
          </lzc:fields>
        </lzc:object-ref>
      </lzc:all-fields>
    </lzc:object>
    <lzc:object name="TestWindow" alias="TestWindow" filename="TestWindow" namespace="ASTD.CIPortal" friendly-name="TestWindow" logical-name="TestWindow" db-table="TestWindow" title-field="Name">
      <lzc:description>Defines the possible testing windows (start and end dates) for members.</lzc:description>
      <lzc:fields>
        <lzc:field name="Id" alias="id" autogenerate="True" type="Identity" friendly-name="Id" readonly="False" required="True" tableonly="False" logical-name="Id" dbname="Id" dbtype="Int">
          <lzc:indexes>
            <lzc:index name="PK_TestWindow" type="Primary" constraintname="PK_TestWindow_Id" cascade-delete="False" />
          </lzc:indexes>
        </lzc:field>
        <lzc:field name="Name" alias="name" autogenerate="False" type="Varchar" friendly-name="Name" readonly="False" required="True" size="50" tableonly="False" logical-name="Name" dbname="Name" dbtype="Varchar" />
        <lzc:field name="StartDate" alias="startdate" autogenerate="False" type="DateTime" friendly-name="StartDate" readonly="False" required="True" tableonly="False" logical-name="StartDate" dbname="StartDate" dbtype="DateTime" />
        <lzc:field name="EndDate" alias="enddate" autogenerate="False" type="DateTime" friendly-name="EndDate" readonly="False" required="True" tableonly="False" logical-name="EndDate" dbname="EndDate" dbtype="DateTime" />
        <lzc:field name="Active" alias="active" autogenerate="False" type="Bit" default="1" friendly-name="Active" readonly="False" required="True" tableonly="False" logical-name="Active" dbname="Active" dbtype="Bit" />
      </lzc:fields>
      <lzc:all-fields>
        <lzc:object-ref ref="TestWindow">
          <lzc:fields>
            <lzc:field name="Id" alias="id" autogenerate="True" type="Identity" friendly-name="Id" readonly="False" required="True" tableonly="False" logical-name="Id" dbname="Id" dbtype="Int">
              <lzc:indexes>
                <lzc:index name="PK_TestWindow" type="Primary" constraintname="PK_TestWindow_Id" cascade-delete="False" />
              </lzc:indexes>
            </lzc:field>
            <lzc:field name="Name" alias="name" autogenerate="False" type="Varchar" friendly-name="Name" readonly="False" required="True" size="50" tableonly="False" logical-name="Name" dbname="Name" dbtype="Varchar" />
            <lzc:field name="StartDate" alias="startdate" autogenerate="False" type="DateTime" friendly-name="StartDate" readonly="False" required="True" tableonly="False" logical-name="StartDate" dbname="StartDate" dbtype="DateTime" />
            <lzc:field name="EndDate" alias="enddate" autogenerate="False" type="DateTime" friendly-name="EndDate" readonly="False" required="True" tableonly="False" logical-name="EndDate" dbname="EndDate" dbtype="DateTime" />
            <lzc:field name="Active" alias="active" autogenerate="False" type="Bit" default="1" friendly-name="Active" readonly="False" required="True" tableonly="False" logical-name="Active" dbname="Active" dbtype="Bit" />
          </lzc:fields>
        </lzc:object-ref>
      </lzc:all-fields>
    </lzc:object>
    <lzc:object name="TestStatus" alias="TestStatus" filename="TestStatus" namespace="ASTD.CIPortal" friendly-name="TestStatus" logical-name="TestStatus" db-table="TestStatus">
      <lzc:description>Defines the possible status codes for a member's testing completion.</lzc:description>
      <lzc:fields>
        <lzc:field name="Id" alias="id" autogenerate="True" type="Identity" friendly-name="Id" readonly="False" required="True" tableonly="False" logical-name="Id" dbname="Id" dbtype="Int">
          <lzc:indexes>
            <lzc:index name="PK_TestStatus" type="Primary" constraintname="PK_TestStatus_Id" cascade-delete="False" />
          </lzc:indexes>
        </lzc:field>
        <lzc:field name="Title" alias="title" autogenerate="False" type="Varchar" friendly-name="Title" readonly="False" required="True" size="50" tableonly="False" logical-name="Title" dbname="Title" dbtype="Varchar" />
      </lzc:fields>
      <lzc:all-fields>
        <lzc:object-ref ref="TestStatus">
          <lzc:fields>
            <lzc:field name="Id" alias="id" autogenerate="True" type="Identity" friendly-name="Id" readonly="False" required="True" tableonly="False" logical-name="Id" dbname="Id" dbtype="Int">
              <lzc:indexes>
                <lzc:index name="PK_TestStatus" type="Primary" constraintname="PK_TestStatus_Id" cascade-delete="False" />
              </lzc:indexes>
            </lzc:field>
            <lzc:field name="Title" alias="title" autogenerate="False" type="Varchar" friendly-name="Title" readonly="False" required="True" size="50" tableonly="False" logical-name="Title" dbname="Title" dbtype="Varchar" />
          </lzc:fields>
        </lzc:object-ref>
      </lzc:all-fields>
    </lzc:object>
    <lzc:object name="CustomerExpertise" alias="CustomerExpertise" filename="CustomerExpertise" namespace="ASTD.CIPortal" friendly-name="CustomerExpertise" logical-name="CustomerExpertise" db-table="CustomerExpertise">
      <lzc:fields>
        <lzc:field name="Id" alias="id" autogenerate="True" type="Identity" friendly-name="Id" readonly="False" required="True" tableonly="False" logical-name="Id" dbname="Id" dbtype="Int">
          <lzc:indexes>
            <lzc:index name="PK_CustomerExpertise" type="Primary" constraintname="PK_CustomerExpertise_Id" cascade-delete="False" />
          </lzc:indexes>
        </lzc:field>
        <lzc:field name="Customer" alias="customer" autogenerate="False" type="Int" friendly-name="Customer" readonly="False" required="False" tableonly="False" logical-name="Customer" dbname="CustomerId" dbtype="Int">
          <lzc:indexes>
            <lzc:index name="IDX_CustomerExpertise_Customer" alias="customer" accessor="Customer" object="Customer" type="Foreign" constraintname="FK_CustomerExpertise_Customer" cascade-delete="False" />
          </lzc:indexes>
        </lzc:field>
        <lzc:field name="AreaOfExpertise" alias="areaofexpertise" autogenerate="False" type="Int" friendly-name="AreaOfExpertise" readonly="False" required="False" tableonly="False" logical-name="AreaOfExpertise" dbname="AreaOfExpertiseId" dbtype="Int">
          <lzc:indexes>
            <lzc:index name="IDX_CustomerExpertise_AreaOfExpertise" alias="areaofexpertise" accessor="AreaOfExpertise" object="PicklistItem" type="Foreign" constraintname="FK_CustomerExpertise_AreaOfExpertise" cascade-delete="False" />
          </lzc:indexes>
        </lzc:field>
      </lzc:fields>
      <lzc:all-fields>
        <lzc:object-ref ref="CustomerExpertise">
          <lzc:fields>
            <lzc:field name="Id" alias="id" autogenerate="True" type="Identity" friendly-name="Id" readonly="False" required="True" tableonly="False" logical-name="Id" dbname="Id" dbtype="Int">
              <lzc:indexes>
                <lzc:index name="PK_CustomerExpertise" type="Primary" constraintname="PK_CustomerExpertise_Id" cascade-delete="False" />
              </lzc:indexes>
            </lzc:field>
            <lzc:field name="Customer" alias="customer" autogenerate="False" type="Int" friendly-name="Customer" readonly="False" required="False" tableonly="False" logical-name="Customer" dbname="CustomerId" dbtype="Int">
              <lzc:indexes>
                <lzc:index name="IDX_CustomerExpertise_Customer" alias="customer" accessor="Customer" object="Customer" type="Foreign" constraintname="FK_CustomerExpertise_Customer" cascade-delete="False" />
              </lzc:indexes>
            </lzc:field>
            <lzc:field name="AreaOfExpertise" alias="areaofexpertise" autogenerate="False" type="Int" friendly-name="AreaOfExpertise" readonly="False" required="False" tableonly="False" logical-name="AreaOfExpertise" dbname="AreaOfExpertiseId" dbtype="Int">
              <lzc:indexes>
                <lzc:index name="IDX_CustomerExpertise_AreaOfExpertise" alias="areaofexpertise" accessor="AreaOfExpertise" object="PicklistItem" type="Foreign" constraintname="FK_CustomerExpertise_AreaOfExpertise" cascade-delete="False" />
              </lzc:indexes>
            </lzc:field>
          </lzc:fields>
        </lzc:object-ref>
      </lzc:all-fields>
    </lzc:object>
    <lzc:object name="CustomerAccomodation" alias="CustomerAccomodation" filename="CustomerAccomodation" namespace="ASTD.CIPortal" friendly-name="CustomerAccomodation" logical-name="CustomerAccomodation" db-table="CustomerAccomodation">
      <lzc:fields>
        <lzc:field name="Id" alias="id" autogenerate="True" type="Identity" friendly-name="Id" readonly="False" required="True" tableonly="False" logical-name="Id" dbname="Id" dbtype="Int">
          <lzc:indexes>
            <lzc:index name="PK_CustomerAccomodation" type="Primary" constraintname="PK_CustomerAccomodation_Id" cascade-delete="False" />
          </lzc:indexes>
        </lzc:field>
        <lzc:field name="Customer" alias="customer" autogenerate="False" type="Int" friendly-name="Customer" readonly="False" required="False" tableonly="False" logical-name="Customer" dbname="CustomerId" dbtype="Int">
          <lzc:indexes>
            <lzc:index name="IDX_CustomerAccomodation_Customer" alias="customer" accessor="Customer" object="Customer" type="Foreign" constraintname="FK_CustomerAccomodation_Customer" cascade-delete="False" />
          </lzc:indexes>
        </lzc:field>
        <lzc:field name="ADACode" alias="adacode" autogenerate="False" type="Int" friendly-name="ADACode" readonly="False" required="False" tableonly="False" logical-name="ADACode" dbname="ADACodeId" dbtype="Int">
          <lzc:indexes>
            <lzc:index name="IDX_CustomerAccomodation_ADACode" alias="adacode" accessor="ADACode" object="PicklistItem" type="Foreign" constraintname="FK_CustomerAccomodation_ADACode" cascade-delete="False" />
          </lzc:indexes>
        </lzc:field>
      </lzc:fields>
      <lzc:all-fields>
        <lzc:object-ref ref="CustomerAccomodation">
          <lzc:fields>
            <lzc:field name="Id" alias="id" autogenerate="True" type="Identity" friendly-name="Id" readonly="False" required="True" tableonly="False" logical-name="Id" dbname="Id" dbtype="Int">
              <lzc:indexes>
                <lzc:index name="PK_CustomerAccomodation" type="Primary" constraintname="PK_CustomerAccomodation_Id" cascade-delete="False" />
              </lzc:indexes>
            </lzc:field>
            <lzc:field name="Customer" alias="customer" autogenerate="False" type="Int" friendly-name="Customer" readonly="False" required="False" tableonly="False" logical-name="Customer" dbname="CustomerId" dbtype="Int">
              <lzc:indexes>
                <lzc:index name="IDX_CustomerAccomodation_Customer" alias="customer" accessor="Customer" object="Customer" type="Foreign" constraintname="FK_CustomerAccomodation_Customer" cascade-delete="False" />
              </lzc:indexes>
            </lzc:field>
            <lzc:field name="ADACode" alias="adacode" autogenerate="False" type="Int" friendly-name="ADACode" readonly="False" required="False" tableonly="False" logical-name="ADACode" dbname="ADACodeId" dbtype="Int">
              <lzc:indexes>
                <lzc:index name="IDX_CustomerAccomodation_ADACode" alias="adacode" accessor="ADACode" object="PicklistItem" type="Foreign" constraintname="FK_CustomerAccomodation_ADACode" cascade-delete="False" />
              </lzc:indexes>
            </lzc:field>
          </lzc:fields>
        </lzc:object-ref>
      </lzc:all-fields>
    </lzc:object>
    <lzc:object name="Employer" alias="Employer" filename="Employer" namespace="ASTD.CIPortal" friendly-name="Employer" logical-name="Employer" db-table="Employer">
      <lzc:fields>
        <lzc:field name="Id" alias="id" autogenerate="True" type="Identity" friendly-name="Id" readonly="False" required="True" tableonly="False" logical-name="Id" dbname="Id" dbtype="Int">
          <lzc:indexes>
            <lzc:index name="PK_Employer" type="Primary" constraintname="PK_Employer_Id" cascade-delete="False" />
          </lzc:indexes>
        </lzc:field>
        <lzc:field name="Customer" alias="customer" autogenerate="False" type="Int" friendly-name="Customer" readonly="False" required="False" tableonly="False" logical-name="Customer" dbname="CustomerId" dbtype="Int">
          <lzc:indexes>
            <lzc:index name="IDX_Employer_Customer" alias="customer" accessor="Customer" object="Customer" type="Foreign" constraintname="FK_Employer_Customer" cascade-delete="False" />
          </lzc:indexes>
        </lzc:field>
        <lzc:field name="Name" alias="name" autogenerate="False" type="Varchar" friendly-name="Name" readonly="False" required="True" size="50" tableonly="False" logical-name="Name" dbname="Name" dbtype="Varchar" />
        <lzc:field name="EmployedFrom" alias="employedfrom" autogenerate="False" type="DateTime" friendly-name="EmployedFrom" readonly="False" required="False" tableonly="False" logical-name="EmployedFrom" dbname="EmployedFrom" dbtype="DateTime" />
        <lzc:field name="EmployedTo" alias="employedto" autogenerate="False" type="DateTime" friendly-name="EmployedTo" readonly="False" required="False" tableonly="False" logical-name="EmployedTo" dbname="EmployedTo" dbtype="DateTime" />
        <lzc:field name="Title" alias="title" autogenerate="False" type="Varchar" friendly-name="Title" readonly="False" required="True" size="50" tableonly="False" logical-name="Title" dbname="Title" dbtype="Varchar" />
        <lzc:field name="Address" alias="address" autogenerate="False" type="Varchar" friendly-name="Address" readonly="False" required="False" size="50" tableonly="False" logical-name="Address" dbname="Address" dbtype="Varchar" />
        <lzc:field name="City" alias="city" autogenerate="False" type="Varchar" friendly-name="City" readonly="False" required="False" size="50" tableonly="False" logical-name="City" dbname="City" dbtype="Varchar" />
        <lzc:field name="State" alias="state" autogenerate="False" type="Int" friendly-name="State" readonly="False" required="False" tableonly="False" logical-name="State" dbname="StateId" dbtype="Int">
          <lzc:indexes>
            <lzc:index name="IDX_Employer_State" alias="state" accessor="State" object="PicklistItem" type="Foreign" constraintname="FK_Employer_State" cascade-delete="False" />
          </lzc:indexes>
        </lzc:field>
        <lzc:field name="Country" alias="country" autogenerate="False" type="Int" friendly-name="Country" readonly="False" required="False" tableonly="False" logical-name="Country" dbname="CountryId" dbtype="Int">
          <lzc:indexes>
            <lzc:index name="IDX_Employer_Country" alias="country" accessor="Country" object="PicklistItem" type="Foreign" constraintname="FK_Employer_Country" cascade-delete="False" />
          </lzc:indexes>
        </lzc:field>
        <lzc:field name="ZipCode" alias="zipcode" autogenerate="False" type="Varchar" friendly-name="ZipCode" readonly="False" required="False" size="10" tableonly="False" logical-name="ZipCode" dbname="ZipCode" dbtype="Varchar" />
      </lzc:fields>
      <lzc:all-fields>
        <lzc:object-ref ref="Employer">
          <lzc:fields>
            <lzc:field name="Id" alias="id" autogenerate="True" type="Identity" friendly-name="Id" readonly="False" required="True" tableonly="False" logical-name="Id" dbname="Id" dbtype="Int">
              <lzc:indexes>
                <lzc:index name="PK_Employer" type="Primary" constraintname="PK_Employer_Id" cascade-delete="False" />
              </lzc:indexes>
            </lzc:field>
            <lzc:field name="Customer" alias="customer" autogenerate="False" type="Int" friendly-name="Customer" readonly="False" required="False" tableonly="False" logical-name="Customer" dbname="CustomerId" dbtype="Int">
              <lzc:indexes>
                <lzc:index name="IDX_Employer_Customer" alias="customer" accessor="Customer" object="Customer" type="Foreign" constraintname="FK_Employer_Customer" cascade-delete="False" />
              </lzc:indexes>
            </lzc:field>
            <lzc:field name="Name" alias="name" autogenerate="False" type="Varchar" friendly-name="Name" readonly="False" required="True" size="50" tableonly="False" logical-name="Name" dbname="Name" dbtype="Varchar" />
            <lzc:field name="EmployedFrom" alias="employedfrom" autogenerate="False" type="DateTime" friendly-name="EmployedFrom" readonly="False" required="False" tableonly="False" logical-name="EmployedFrom" dbname="EmployedFrom" dbtype="DateTime" />
            <lzc:field name="EmployedTo" alias="employedto" autogenerate="False" type="DateTime" friendly-name="EmployedTo" readonly="False" required="False" tableonly="False" logical-name="EmployedTo" dbname="EmployedTo" dbtype="DateTime" />
            <lzc:field name="Title" alias="title" autogenerate="False" type="Varchar" friendly-name="Title" readonly="False" required="True" size="50" tableonly="False" logical-name="Title" dbname="Title" dbtype="Varchar" />
            <lzc:field name="Address" alias="address" autogenerate="False" type="Varchar" friendly-name="Address" readonly="False" required="False" size="50" tableonly="False" logical-name="Address" dbname="Address" dbtype="Varchar" />
            <lzc:field name="City" alias="city" autogenerate="False" type="Varchar" friendly-name="City" readonly="False" required="False" size="50" tableonly="False" logical-name="City" dbname="City" dbtype="Varchar" />
            <lzc:field name="State" alias="state" autogenerate="False" type="Int" friendly-name="State" readonly="False" required="False" tableonly="False" logical-name="State" dbname="StateId" dbtype="Int">
              <lzc:indexes>
                <lzc:index name="IDX_Employer_State" alias="state" accessor="State" object="PicklistItem" type="Foreign" constraintname="FK_Employer_State" cascade-delete="False" />
              </lzc:indexes>
            </lzc:field>
            <lzc:field name="Country" alias="country" autogenerate="False" type="Int" friendly-name="Country" readonly="False" required="False" tableonly="False" logical-name="Country" dbname="CountryId" dbtype="Int">
              <lzc:indexes>
                <lzc:index name="IDX_Employer_Country" alias="country" accessor="Country" object="PicklistItem" type="Foreign" constraintname="FK_Employer_Country" cascade-delete="False" />
              </lzc:indexes>
            </lzc:field>
            <lzc:field name="ZipCode" alias="zipcode" autogenerate="False" type="Varchar" friendly-name="ZipCode" readonly="False" required="False" size="10" tableonly="False" logical-name="ZipCode" dbname="ZipCode" dbtype="Varchar" />
          </lzc:fields>
        </lzc:object-ref>
      </lzc:all-fields>
    </lzc:object>
    <lzc:object name="Institution" alias="Institution" filename="Institution" namespace="ASTD.CIPortal" friendly-name="Institution" logical-name="Institution" db-table="Institution">
      <lzc:fields>
        <lzc:field name="Id" alias="id" autogenerate="True" type="Identity" friendly-name="Id" readonly="False" required="True" tableonly="False" logical-name="Id" dbname="Id" dbtype="Int">
          <lzc:indexes>
            <lzc:index name="PK_Institution" type="Primary" constraintname="PK_Institution_Id" cascade-delete="False" />
          </lzc:indexes>
        </lzc:field>
        <lzc:field name="Customer" alias="customer" autogenerate="False" type="Int" friendly-name="Customer" readonly="False" required="False" tableonly="False" logical-name="Customer" dbname="CustomerId" dbtype="Int">
          <lzc:indexes>
            <lzc:index name="IDX_Institution_Customer" alias="customer" accessor="Customer" object="Customer" type="Foreign" constraintname="FK_Institution_Customer" cascade-delete="False" />
          </lzc:indexes>
        </lzc:field>
        <lzc:field name="From" alias="from" autogenerate="False" type="DateTime" friendly-name="From" readonly="False" required="False" tableonly="False" logical-name="From" dbname="From" dbtype="DateTime" />
        <lzc:field name="To" alias="to" autogenerate="False" type="DateTime" friendly-name="To" readonly="False" required="False" tableonly="False" logical-name="To" dbname="To" dbtype="DateTime" />
        <lzc:field name="Name" alias="name" autogenerate="False" type="Varchar" friendly-name="Name" readonly="False" required="True" size="50" tableonly="False" logical-name="Name" dbname="Name" dbtype="Varchar" />
        <lzc:field name="Address" alias="address" autogenerate="False" type="Varchar" friendly-name="Address" readonly="False" required="False" size="50" tableonly="False" logical-name="Address" dbname="Address" dbtype="Varchar" />
        <lzc:field name="City" alias="city" autogenerate="False" type="Varchar" friendly-name="City" readonly="False" required="False" size="50" tableonly="False" logical-name="City" dbname="City" dbtype="Varchar" />
        <lzc:field name="State" alias="state" autogenerate="False" type="Int" friendly-name="State" readonly="False" required="False" tableonly="False" logical-name="State" dbname="StateId" dbtype="Int">
          <lzc:indexes>
            <lzc:index name="IDX_Institution_State" alias="state" accessor="State" object="PicklistItem" type="Foreign" constraintname="FK_Institution_State" cascade-delete="False" />
          </lzc:indexes>
        </lzc:field>
        <lzc:field name="Country" alias="country" autogenerate="False" type="Int" friendly-name="Country" readonly="False" required="False" tableonly="False" logical-name="Country" dbname="CountryId" dbtype="Int">
          <lzc:indexes>
            <lzc:index name="IDX_Institution_Country" alias="country" accessor="Country" object="PicklistItem" type="Foreign" constraintname="FK_Institution_Country" cascade-delete="False" />
          </lzc:indexes>
        </lzc:field>
        <lzc:field name="ZipCode" alias="zipcode" autogenerate="False" type="Varchar" friendly-name="ZipCode" readonly="False" required="False" size="10" tableonly="False" logical-name="ZipCode" dbname="ZipCode" dbtype="Varchar" />
        <lzc:field name="Email" alias="email" autogenerate="False" type="Varchar" friendly-name="Email" readonly="False" required="False" size="255" tableonly="False" logical-name="Email" dbname="Email" dbtype="Varchar" />
      </lzc:fields>
      <lzc:all-fields>
        <lzc:object-ref ref="Institution">
          <lzc:fields>
            <lzc:field name="Id" alias="id" autogenerate="True" type="Identity" friendly-name="Id" readonly="False" required="True" tableonly="False" logical-name="Id" dbname="Id" dbtype="Int">
              <lzc:indexes>
                <lzc:index name="PK_Institution" type="Primary" constraintname="PK_Institution_Id" cascade-delete="False" />
              </lzc:indexes>
            </lzc:field>
            <lzc:field name="Customer" alias="customer" autogenerate="False" type="Int" friendly-name="Customer" readonly="False" required="False" tableonly="False" logical-name="Customer" dbname="CustomerId" dbtype="Int">
              <lzc:indexes>
                <lzc:index name="IDX_Institution_Customer" alias="customer" accessor="Customer" object="Customer" type="Foreign" constraintname="FK_Institution_Customer" cascade-delete="False" />
              </lzc:indexes>
            </lzc:field>
            <lzc:field name="From" alias="from" autogenerate="False" type="DateTime" friendly-name="From" readonly="False" required="False" tableonly="False" logical-name="From" dbname="From" dbtype="DateTime" />
            <lzc:field name="To" alias="to" autogenerate="False" type="DateTime" friendly-name="To" readonly="False" required="False" tableonly="False" logical-name="To" dbname="To" dbtype="DateTime" />
            <lzc:field name="Name" alias="name" autogenerate="False" type="Varchar" friendly-name="Name" readonly="False" required="True" size="50" tableonly="False" logical-name="Name" dbname="Name" dbtype="Varchar" />
            <lzc:field name="Address" alias="address" autogenerate="False" type="Varchar" friendly-name="Address" readonly="False" required="False" size="50" tableonly="False" logical-name="Address" dbname="Address" dbtype="Varchar" />
            <lzc:field name="City" alias="city" autogenerate="False" type="Varchar" friendly-name="City" readonly="False" required="False" size="50" tableonly="False" logical-name="City" dbname="City" dbtype="Varchar" />
            <lzc:field name="State" alias="state" autogenerate="False" type="Int" friendly-name="State" readonly="False" required="False" tableonly="False" logical-name="State" dbname="StateId" dbtype="Int">
              <lzc:indexes>
                <lzc:index name="IDX_Institution_State" alias="state" accessor="State" object="PicklistItem" type="Foreign" constraintname="FK_Institution_State" cascade-delete="False" />
              </lzc:indexes>
            </lzc:field>
            <lzc:field name="Country" alias="country" autogenerate="False" type="Int" friendly-name="Country" readonly="False" required="False" tableonly="False" logical-name="Country" dbname="CountryId" dbtype="Int">
              <lzc:indexes>
                <lzc:index name="IDX_Institution_Country" alias="country" accessor="Country" object="PicklistItem" type="Foreign" constraintname="FK_Institution_Country" cascade-delete="False" />
              </lzc:indexes>
            </lzc:field>
            <lzc:field name="ZipCode" alias="zipcode" autogenerate="False" type="Varchar" friendly-name="ZipCode" readonly="False" required="False" size="10" tableonly="False" logical-name="ZipCode" dbname="ZipCode" dbtype="Varchar" />
            <lzc:field name="Email" alias="email" autogenerate="False" type="Varchar" friendly-name="Email" readonly="False" required="False" size="255" tableonly="False" logical-name="Email" dbname="Email" dbtype="Varchar" />
          </lzc:fields>
        </lzc:object-ref>
      </lzc:all-fields>
    </lzc:object>
    <lzc:object name="Reference" alias="Reference" filename="Reference" namespace="ASTD.CIPortal" friendly-name="Reference" logical-name="Reference" db-table="Reference">
      <lzc:fields>
        <lzc:field name="Id" alias="id" autogenerate="True" type="Identity" friendly-name="Id" readonly="False" required="True" tableonly="False" logical-name="Id" dbname="Id" dbtype="Int">
          <lzc:indexes>
            <lzc:index name="PK_Reference" type="Primary" constraintname="PK_Reference_Id" cascade-delete="False" />
          </lzc:indexes>
        </lzc:field>
        <lzc:field name="Customer" alias="customer" autogenerate="False" type="Int" friendly-name="Customer" readonly="False" required="False" tableonly="False" logical-name="Customer" dbname="CustomerId" dbtype="Int">
          <lzc:indexes>
            <lzc:index name="IDX_Reference_Customer" alias="customer" accessor="Customer" object="Customer" type="Foreign" constraintname="FK_Reference_Customer" cascade-delete="False" />
          </lzc:indexes>
        </lzc:field>
        <lzc:field name="Name" alias="name" autogenerate="False" type="Varchar" friendly-name="Name" readonly="False" required="False" size="50" tableonly="False" logical-name="Name" dbname="Name" dbtype="Varchar" />
        <lzc:field name="Title" alias="title" autogenerate="False" type="Varchar" friendly-name="Title" readonly="False" required="False" size="50" tableonly="False" logical-name="Title" dbname="Title" dbtype="Varchar" />
        <lzc:field name="Telephone" alias="telephone" autogenerate="False" type="Varchar" friendly-name="Telephone" readonly="False" required="False" size="20" tableonly="False" logical-name="Telephone" dbname="Telephone" dbtype="Varchar" />
        <lzc:field name="Email" alias="email" autogenerate="False" type="Varchar" friendly-name="Email" readonly="False" required="False" size="255" tableonly="False" logical-name="Email" dbname="Email" dbtype="Varchar" />
      </lzc:fields>
      <lzc:all-fields>
        <lzc:object-ref ref="Reference">
          <lzc:fields>
            <lzc:field name="Id" alias="id" autogenerate="True" type="Identity" friendly-name="Id" readonly="False" required="True" tableonly="False" logical-name="Id" dbname="Id" dbtype="Int">
              <lzc:indexes>
                <lzc:index name="PK_Reference" type="Primary" constraintname="PK_Reference_Id" cascade-delete="False" />
              </lzc:indexes>
            </lzc:field>
            <lzc:field name="Customer" alias="customer" autogenerate="False" type="Int" friendly-name="Customer" readonly="False" required="False" tableonly="False" logical-name="Customer" dbname="CustomerId" dbtype="Int">
              <lzc:indexes>
                <lzc:index name="IDX_Reference_Customer" alias="customer" accessor="Customer" object="Customer" type="Foreign" constraintname="FK_Reference_Customer" cascade-delete="False" />
              </lzc:indexes>
            </lzc:field>
            <lzc:field name="Name" alias="name" autogenerate="False" type="Varchar" friendly-name="Name" readonly="False" required="False" size="50" tableonly="False" logical-name="Name" dbname="Name" dbtype="Varchar" />
            <lzc:field name="Title" alias="title" autogenerate="False" type="Varchar" friendly-name="Title" readonly="False" required="False" size="50" tableonly="False" logical-name="Title" dbname="Title" dbtype="Varchar" />
            <lzc:field name="Telephone" alias="telephone" autogenerate="False" type="Varchar" friendly-name="Telephone" readonly="False" required="False" size="20" tableonly="False" logical-name="Telephone" dbname="Telephone" dbtype="Varchar" />
            <lzc:field name="Email" alias="email" autogenerate="False" type="Varchar" friendly-name="Email" readonly="False" required="False" size="255" tableonly="False" logical-name="Email" dbname="Email" dbtype="Varchar" />
          </lzc:fields>
        </lzc:object-ref>
      </lzc:all-fields>
    </lzc:object>
  </lzc:objects>
  <lzc:tables>
    <lzc:table name="Settings" alias="Settings" filename="Settings" namespace="ASTD.CIPortal" friendly-name="Settings" logical-name="Settings">
      <lzc:description>Defines various application-level read/write settings.</lzc:description>
      <lzc:fields>
        <lzc:field name="Id" alias="id" autogenerate="True" type="Identity" friendly-name="Id" readonly="False" required="True" tableonly="False" logical-name="Id" dbname="Id" dbtype="Int">
          <lzc:indexes>
            <lzc:index name="PK_Settings" type="Primary" constraintname="PK_Settings_Id" cascade-delete="False" />
          </lzc:indexes>
        </lzc:field>
        <lzc:field name="Name" alias="name" autogenerate="False" type="Varchar" friendly-name="Name" readonly="False" required="True" size="50" tableonly="False" logical-name="Name" dbname="Name" dbtype="Varchar" />
        <lzc:field name="Value" alias="value" autogenerate="False" type="Varchar" friendly-name="Value" readonly="False" required="True" size="255" tableonly="False" logical-name="Value" dbname="Value" dbtype="Varchar" />
      </lzc:fields>
      <lzc:methods>
        <lzc:method name="Create" object-name="Create" db-name="SettingsCreate" methodtype="Create" filename="SettingsCreate" return-result="False">
          <lzc:method-params>
            <lzc:method-param name="Id" dbname="Id" type="Int" required="True" direction="out" />
            <lzc:method-param name="Name" dbname="Name" type="Varchar" size="50" required="True" direction="in" />
            <lzc:method-param name="Value" dbname="Value" type="Varchar" size="255" required="True" direction="in" />
          </lzc:method-params>
          <lzc:method-effects>
            <lzc:object-ref name="Settings" effecttype="Create" ref="Settings" alias="Settings" pkfield="Id" fkfield="Id">
              <lzc:fields>
                <lzc:method-effect field="Id" type="Identity" dbtype="Int" dbname="Id" param="Id" autogenerate="True" />
                <lzc:method-effect field="Name" type="Varchar" dbtype="Varchar" dbname="Name" param="Name" autogenerate="False" />
                <lzc:method-effect field="Value" type="Varchar" dbtype="Varchar" dbname="Value" param="Value" autogenerate="False" />
              </lzc:fields>
            </lzc:object-ref>
          </lzc:method-effects>
        </lzc:method>
        <lzc:method name="Update" object-name="Update" db-name="SettingsUpdate" methodtype="Update" filename="SettingsUpdate" return-result="False">
          <lzc:method-params>
            <lzc:method-param name="Id" dbname="Id" type="Int" required="True" direction="in" />
            <lzc:method-param name="Name" dbname="Name" type="Varchar" size="50" required="True" direction="in" />
            <lzc:method-param name="Value" dbname="Value" type="Varchar" size="255" required="True" direction="in" />
          </lzc:method-params>
          <lzc:method-effects>
            <lzc:object-ref name="Settings" effecttype="Update" ref="Settings" alias="Settings" pkfield="Id" fkfield="Id">
              <lzc:method-filters>
                <lzc:method-filter field="Id" param="Id" />
              </lzc:method-filters>
              <lzc:fields>
                <lzc:method-effect field="Name" type="Varchar" dbtype="Varchar" dbname="Name" param="Name" autogenerate="False" />
                <lzc:method-effect field="Value" type="Varchar" dbtype="Varchar" dbname="Value" param="Value" autogenerate="False" />
              </lzc:fields>
            </lzc:object-ref>
          </lzc:method-effects>
        </lzc:method>
        <lzc:method name="Get" object-name="Get" db-name="SettingsGet" methodtype="Get" filename="SettingsGet" return-result="True">
          <lzc:method-params>
            <lzc:method-param name="Id" dbname="Id" type="Int" required="True" direction="in" />
          </lzc:method-params>
          <lzc:method-filters>
            <lzc:method-filter field="Id" param="Id" />
          </lzc:method-filters>
          <lzc:method-results>
            <lzc:object-ref name="Settings" ref="Settings" alias="Settings" pkfield="Id" fkfield="Id" required="False">
              <lzc:fields>
                <lzc:method-result field="Id" alias="id" type="Int" dbname="Id" />
                <lzc:method-result field="Name" alias="name" type="Varchar" dbname="Name" size="50" />
                <lzc:method-result field="Value" alias="value" type="Varchar" dbname="Value" size="255" />
              </lzc:fields>
            </lzc:object-ref>
          </lzc:method-results>
        </lzc:method>
        <lzc:method name="List" object-name="List" db-name="SettingsList" methodtype="List" filename="SettingsList" return-result="True">
          <lzc:method-results>
            <lzc:object-ref name="Settings" ref="Settings" alias="Settings" fkfield="Id" required="True">
              <lzc:fields>
                <lzc:method-result field="Id" alias="Id" type="Int" dbname="Id" />
                <lzc:method-result field="Name" alias="Name" type="Varchar" dbname="Name" size="50" />
                <lzc:method-result field="Value" alias="Value" type="Varchar" dbname="Value" size="255" />
              </lzc:fields>
            </lzc:object-ref>
          </lzc:method-results>
        </lzc:method>
      </lzc:methods>
    </lzc:table>
    <lzc:table name="Customer" alias="Customer" filename="Customer" namespace="ASTD.CIPortal" friendly-name="Customer" logical-name="Customer">
      <lzc:fields>
        <lzc:field name="Id" alias="id" autogenerate="True" type="Identity" friendly-name="Id" readonly="False" required="True" tableonly="False" logical-name="Id" dbname="Id" dbtype="Int">
          <lzc:indexes>
            <lzc:index name="PK_Customer" type="Primary" constraintname="PK_Customer_Id" cascade-delete="False" />
          </lzc:indexes>
        </lzc:field>
        <lzc:field name="NameFirst" alias="namefirst" autogenerate="False" type="Varchar" friendly-name="NameFirst" readonly="False" required="False" size="50" tableonly="False" logical-name="NameFirst" dbname="NameFirst" dbtype="Varchar">
          <lzc:description>First name of the customer.</lzc:description>
        </lzc:field>
        <lzc:field name="NameMiddle" alias="namemiddle" autogenerate="False" type="Varchar" friendly-name="NameMiddle" readonly="False" required="False" size="50" tableonly="False" logical-name="NameMiddle" dbname="NameMiddle" dbtype="Varchar">
          <lzc:description>Middle name (or initial) of the customer.</lzc:description>
        </lzc:field>
        <lzc:field name="NameLast" alias="namelast" autogenerate="False" type="Varchar" friendly-name="NameLast" readonly="False" required="False" size="50" tableonly="False" logical-name="NameLast" dbname="NameLast" dbtype="Varchar">
          <lzc:description>Last name of the customer.</lzc:description>
        </lzc:field>
        <lzc:field name="Suffix" alias="suffix" autogenerate="False" type="Varchar" friendly-name="Suffix" readonly="False" required="False" size="10" tableonly="False" logical-name="Suffix" dbname="Suffix" dbtype="Varchar">
          <lzc:description>Specifies the customer's name suffix (Jr., Sr., etc.).</lzc:description>
        </lzc:field>
        <lzc:field name="Prefix" alias="prefix" autogenerate="False" type="Varchar" friendly-name="Prefix" readonly="False" required="False" size="10" tableonly="False" logical-name="Prefix" dbname="Prefix" dbtype="Varchar">
          <lzc:description>Specifies the customer's name prefix or title (Mr., Mrs., etc.)</lzc:description>
        </lzc:field>
        <lzc:field name="Industry" alias="industry" autogenerate="False" type="Int" friendly-name="Industry" readonly="False" required="False" tableonly="False" logical-name="Industry" dbname="IndustryId" dbtype="Int">
          <lzc:description>Specifies the industry that best describes where the customer conducts his/her work.</lzc:description>
          <lzc:indexes>
            <lzc:index name="IDX_Customer_Industry" alias="industry" accessor="Industry" object="PicklistItem" type="Foreign" constraintname="FK_Customer_Industry" cascade-delete="False" />
          </lzc:indexes>
        </lzc:field>
        <lzc:field name="OrganizationType" alias="organizationtype" autogenerate="False" type="Int" friendly-name="OrganizationType" readonly="False" required="False" tableonly="False" logical-name="OrganizationType" dbname="OrganizationTypeId" dbtype="Int">
          <lzc:indexes>
            <lzc:index name="IDX_Customer_OrganizationType" alias="organizationtype" accessor="OrganizationType" object="PicklistItem" type="Foreign" constraintname="FK_Customer_OrganizationType" cascade-delete="False" />
          </lzc:indexes>
        </lzc:field>
        <lzc:field name="AreaOfExpertise" alias="areaofexpertise" autogenerate="False" type="Int" friendly-name="AreaOfExpertise" readonly="False" required="False" tableonly="False" logical-name="AreaOfExpertise" dbname="AreaOfExpertiseId" dbtype="Int">
          <lzc:description>This specifies the Area of Expertise for the CPLP Work Product submission.</lzc:description>
          <lzc:indexes>
            <lzc:index name="IDX_Customer_AreaOfExpertise" alias="areaofexpertise" accessor="AreaOfExpertise" object="PicklistItem" type="Foreign" constraintname="FK_Customer_AreaOfExpertise" cascade-delete="False" />
          </lzc:indexes>
        </lzc:field>
        <lzc:field name="PrimaryAreaOfResponsibility" alias="primaryareaofresponsibility" autogenerate="False" type="Int" friendly-name="PrimaryAreaOfResponsibility" readonly="False" required="False" tableonly="False" logical-name="PrimaryAreaOfResponsibility" dbname="PrimaryAreaOfResponsibilityId" dbtype="Int">
          <lzc:indexes>
            <lzc:index name="IDX_Customer_PrimaryAreaOfResponsibility" alias="primaryareaofresponsibility" accessor="PrimaryAreaOfResponsibility" object="PicklistItem" type="Foreign" constraintname="FK_Customer_PrimaryAreaOfResponsibility" cascade-delete="False" />
          </lzc:indexes>
        </lzc:field>
        <lzc:field name="Gender" alias="gender" autogenerate="False" type="Varchar" friendly-name="Gender" readonly="False" required="False" size="1" tableonly="False" logical-name="Gender" dbname="Gender" dbtype="Varchar" />
        <lzc:field name="Ethnicity" alias="ethnicity" autogenerate="False" type="Int" friendly-name="Ethnicity" readonly="False" required="False" tableonly="False" logical-name="Ethnicity" dbname="EthnicityId" dbtype="Int">
          <lzc:indexes>
            <lzc:index name="IDX_Customer_Ethnicity" alias="ethnicity" accessor="Ethnicity" object="PicklistItem" type="Foreign" constraintname="FK_Customer_Ethnicity" cascade-delete="False" />
          </lzc:indexes>
        </lzc:field>
        <lzc:field name="SpanOfControl" alias="spanofcontrol" autogenerate="False" type="Int" friendly-name="SpanOfControl" readonly="False" required="False" tableonly="False" logical-name="SpanOfControl" dbname="SpanOfControlId" dbtype="Int">
          <lzc:indexes>
            <lzc:index name="IDX_Customer_SpanOfControl" alias="spanofcontrol" accessor="SpanOfControl" object="PicklistItem" type="Foreign" constraintname="FK_Customer_SpanOfControl" cascade-delete="False" />
          </lzc:indexes>
        </lzc:field>
        <lzc:field name="TIMSSCode" alias="timsscode" autogenerate="False" type="Varchar" friendly-name="TIMSSCode" readonly="False" required="False" size="8" tableonly="False" logical-name="TIMSSCode" dbname="TIMSSCode" dbtype="Varchar">
          <lzc:description>Customer ID from the TIMSS system.  This is used to bridge the TIMSS customers to the CIPortal customers.</lzc:description>
        </lzc:field>
        <lzc:field name="TestWindowId" alias="testwindowid" autogenerate="False" type="Int" friendly-name="TestWindowId" readonly="False" required="False" tableonly="False" logical-name="TestWindowId" dbname="TestWindowIdId" dbtype="Int">
          <lzc:indexes>
            <lzc:index name="IDX_Customer_TestWindowId" alias="testwindowid" accessor="TestWindowId" object="TestWindow" type="Foreign" constraintname="FK_Customer_TestWindowId" cascade-delete="False" />
          </lzc:indexes>
        </lzc:field>
        <lzc:field name="TestStatus" alias="teststatus" autogenerate="False" type="Int" default="1" friendly-name="TestStatus" readonly="False" required="True" tableonly="False" logical-name="TestStatus" dbname="TestStatusId" dbtype="Int">
          <lzc:indexes>
            <lzc:index name="IDX_Customer_TestStatus" alias="teststatus" accessor="TestStatus" object="TestStatus" type="Foreign" constraintname="FK_Customer_TestStatus" cascade-delete="False" />
          </lzc:indexes>
        </lzc:field>
        <lzc:field name="WorkSubmissionStatus" alias="worksubmissionstatus" autogenerate="False" type="Int" friendly-name="WorkSubmissionStatus" readonly="False" required="False" tableonly="False" logical-name="WorkSubmissionStatus" dbname="WorkSubmissionStatusId" dbtype="Int">
          <lzc:indexes>
            <lzc:index name="IDX_Customer_WorkSubmissionStatus" alias="worksubmissionstatus" accessor="WorkSubmissionStatus" object="TestStatus" type="Foreign" constraintname="FK_Customer_WorkSubmissionStatus" cascade-delete="False" />
          </lzc:indexes>
        </lzc:field>
        <lzc:field name="SpecialAccomodations" alias="specialaccomodations" autogenerate="False" type="Bit" default="0" friendly-name="SpecialAccomodations" readonly="False" required="True" tableonly="False" logical-name="SpecialAccomodations" dbname="SpecialAccomodations" dbtype="Bit">
          <lzc:description>This records whether or not the potential member has specified he/she needs special ADA accomodations.  ASTD Personnel will invistigate and provide the detailed accomodations required.</lzc:description>
        </lzc:field>
        <lzc:field name="YearsInWorkplace" alias="yearsinworkplace" autogenerate="False" type="Smallint" default="0" friendly-name="YearsInWorkplace" readonly="False" required="True" tableonly="False" logical-name="YearsInWorkplace" dbname="YearsInWorkplace" dbtype="Smallint">
          <lzc:description>This specifies the total number of years the potential member has been in the workplace, regardless of specific subject matter.</lzc:description>
        </lzc:field>
        <lzc:field name="OrganizationDescription" alias="organizationdescription" autogenerate="False" type="Text" friendly-name="OrganizationDescription" readonly="False" required="False" tableonly="False" logical-name="OrganizationDescription" dbname="OrganizationDescription" dbtype="Text" />
        <lzc:field name="Eligibility" alias="eligibility" autogenerate="False" type="Int" friendly-name="Eligibility" readonly="False" required="False" tableonly="False" logical-name="Eligibility" dbname="EligibilityId" dbtype="Int">
          <lzc:indexes>
            <lzc:index name="IDX_Customer_Eligibility" alias="eligibility" accessor="Eligibility" object="PicklistItem" type="Foreign" constraintname="FK_Customer_Eligibility" cascade-delete="False" />
          </lzc:indexes>
        </lzc:field>
        <lzc:field name="DegreeAttained" alias="degreeattained" autogenerate="False" type="Int" friendly-name="DegreeAttained" readonly="False" required="False" tableonly="False" logical-name="DegreeAttained" dbname="DegreeAttainedId" dbtype="Int">
          <lzc:description>The degree selected here should represent a field of study relevant to your degree.</lzc:description>
          <lzc:indexes>
            <lzc:index name="IDX_Customer_DegreeAttained" alias="degreeattained" accessor="DegreeAttained" object="PicklistItem" type="Foreign" constraintname="FK_Customer_DegreeAttained" cascade-delete="False" />
          </lzc:indexes>
        </lzc:field>
        <lzc:field name="YearGraduated" alias="yeargraduated" autogenerate="False" type="Smallint" friendly-name="YearGraduated" readonly="False" required="False" tableonly="False" logical-name="YearGraduated" dbname="YearGraduated" dbtype="Smallint">
          <lzc:description>This specifies the year graduated for their highest degree attained.</lzc:description>
        </lzc:field>
        <lzc:field name="CurrentStudent" alias="currentstudent" autogenerate="False" type="Bit" default="0" friendly-name="CurrentStudent" readonly="False" required="True" tableonly="False" logical-name="CurrentStudent" dbname="CurrentStudent" dbtype="Bit">
          <lzc:description>Specifies whether or not the customer is currently a student.</lzc:description>
        </lzc:field>
        <lzc:field name="HoldList" alias="holdlist" autogenerate="False" type="Int" friendly-name="HoldList" readonly="False" required="False" tableonly="False" logical-name="HoldList" dbname="HoldListId" dbtype="Int">
          <lzc:description>Specifies a reason that the administrator is holding the customer's account for later inclusion in the program.  Customers on the Hold List will not be exported to the test vendor.</lzc:description>
          <lzc:indexes>
            <lzc:index name="IDX_Customer_HoldList" alias="holdlist" accessor="HoldList" object="PicklistItem" type="Foreign" constraintname="FK_Customer_HoldList" cascade-delete="False" />
          </lzc:indexes>
        </lzc:field>
        <lzc:field name="CodeOfEthicsAcknowledgement" alias="codeofethicsacknowledgement" autogenerate="False" type="Bit" default="0" friendly-name="CodeOfEthicsAcknowledgement" readonly="False" required="True" tableonly="False" logical-name="CodeOfEthicsAcknowledgement" dbname="CodeOfEthicsAcknowledgement" dbtype="Bit" />
        <lzc:field name="ReleaseAgreement" alias="releaseagreement" autogenerate="False" type="Bit" default="0" friendly-name="ReleaseAgreement" readonly="False" required="True" tableonly="False" logical-name="ReleaseAgreement" dbname="ReleaseAgreement" dbtype="Bit" />
        <lzc:field name="FirstTimeTester" alias="firsttimetester" autogenerate="False" type="Bit" default="0" friendly-name="FirstTimeTester" readonly="False" required="True" tableonly="False" logical-name="FirstTimeTester" dbname="FirstTimeTester" dbtype="Bit">
          <lzc:description>Specifies whether or not the customer has taken a CPLP exam before.</lzc:description>
        </lzc:field>
        <lzc:field name="ValidatedByAdmin" alias="validatedbyadmin" autogenerate="False" type="Bit" default="0" friendly-name="ValidatedByAdmin" readonly="False" required="True" tableonly="False" logical-name="ValidatedByAdmin" dbname="ValidatedByAdmin" dbtype="Bit">
          <lzc:description>Indicates that the customer's account has been validated by an authorized administrator.  Customer accounts that have not been validated are not automatically exported.</lzc:description>
        </lzc:field>
        <lzc:field name="Exported" alias="exported" autogenerate="False" type="Bit" default="0" friendly-name="Exported" readonly="False" required="True" tableonly="False" logical-name="Exported" dbname="Exported" dbtype="Bit">
          <lzc:description>Specifies that the customer's information has been exported to the test vendor.</lzc:description>
        </lzc:field>
        <lzc:field name="TestVendorExportDate" alias="testvendorexportdate" autogenerate="False" type="DateTime" friendly-name="TestVendorExportDate" readonly="False" required="False" tableonly="False" logical-name="TestVendorExportDate" dbname="TestVendorExportDate" dbtype="DateTime">
          <lzc:description>Describes the date/time that the customer registration was exported to the Test Vendor.</lzc:description>
        </lzc:field>
        <lzc:field name="ExportOverride" alias="exportoverride" autogenerate="False" type="Bit" default="0" friendly-name="ExportOverride" readonly="False" required="True" tableonly="False" logical-name="ExportOverride" dbname="ExportOverride" dbtype="Bit">
          <lzc:description>Specifies whether the customer's information was manually selected for export to the Test Vendor.</lzc:description>
        </lzc:field>
        <lzc:field name="Address1Line1" alias="address1line1" autogenerate="False" type="Varchar" friendly-name="Address1Line1" readonly="False" required="False" size="100" tableonly="False" logical-name="Address1Line1" dbname="Address1Line1" dbtype="Varchar" />
        <lzc:field name="Address1Line2" alias="address1line2" autogenerate="False" type="Varchar" friendly-name="Address1Line2" readonly="False" required="False" size="100" tableonly="False" logical-name="Address1Line2" dbname="Address1Line2" dbtype="Varchar" />
        <lzc:field name="Address1Line3" alias="address1line3" autogenerate="False" type="Varchar" friendly-name="Address1Line3" readonly="False" required="False" size="100" tableonly="False" logical-name="Address1Line3" dbname="Address1Line3" dbtype="Varchar" />
        <lzc:field name="Address1City" alias="address1city" autogenerate="False" type="Varchar" friendly-name="Address1City" readonly="False" required="False" size="50" tableonly="False" logical-name="Address1City" dbname="Address1City" dbtype="Varchar" />
        <lzc:field name="Address1State" alias="address1state" autogenerate="False" type="Int" friendly-name="Address1State" readonly="False" required="False" tableonly="False" logical-name="Address1State" dbname="Address1StateId" dbtype="Int">
          <lzc:indexes>
            <lzc:index name="IDX_Customer_Address1State" alias="address1state" accessor="Address1State" object="PicklistItem" type="Foreign" constraintname="FK_Customer_Address1State" cascade-delete="False" />
          </lzc:indexes>
        </lzc:field>
        <lzc:field name="Address1Country" alias="address1country" autogenerate="False" type="Int" friendly-name="Address1Country" readonly="False" required="False" tableonly="False" logical-name="Address1Country" dbname="Address1CountryId" dbtype="Int">
          <lzc:indexes>
            <lzc:index name="IDX_Customer_Address1Country" alias="address1country" accessor="Address1Country" object="PicklistItem" type="Foreign" constraintname="FK_Customer_Address1Country" cascade-delete="False" />
          </lzc:indexes>
        </lzc:field>
        <lzc:field name="Address1ZipCode" alias="address1zipcode" autogenerate="False" type="Varchar" friendly-name="Address1ZipCode" readonly="False" required="False" size="10" tableonly="False" logical-name="Address1ZipCode" dbname="Address1ZipCode" dbtype="Varchar" />
        <lzc:field name="Address2Line1" alias="address2line1" autogenerate="False" type="Varchar" friendly-name="Address2Line1" readonly="False" required="False" size="100" tableonly="False" logical-name="Address2Line1" dbname="Address2Line1" dbtype="Varchar" />
        <lzc:field name="Address2Line2" alias="address2line2" autogenerate="False" type="Varchar" friendly-name="Address2Line2" readonly="False" required="False" size="100" tableonly="False" logical-name="Address2Line2" dbname="Address2Line2" dbtype="Varchar" />
        <lzc:field name="Address2Line3" alias="address2line3" autogenerate="False" type="Varchar" friendly-name="Address2Line3" readonly="False" required="False" size="100" tableonly="False" logical-name="Address2Line3" dbname="Address2Line3" dbtype="Varchar" />
        <lzc:field name="Address2City" alias="address2city" autogenerate="False" type="Varchar" friendly-name="Address2City" readonly="False" required="False" size="50" tableonly="False" logical-name="Address2City" dbname="Address2City" dbtype="Varchar" />
        <lzc:field name="Address2State" alias="address2state" autogenerate="False" type="Int" friendly-name="Address2State" readonly="False" required="False" tableonly="False" logical-name="Address2State" dbname="Address2StateId" dbtype="Int">
          <lzc:indexes>
            <lzc:index name="IDX_Customer_Address2State" alias="address2state" accessor="Address2State" object="PicklistItem" type="Foreign" constraintname="FK_Customer_Address2State" cascade-delete="False" />
          </lzc:indexes>
        </lzc:field>
        <lzc:field name="Address2Country" alias="address2country" autogenerate="False" type="Int" friendly-name="Address2Country" readonly="False" required="False" tableonly="False" logical-name="Address2Country" dbname="Address2CountryId" dbtype="Int">
          <lzc:indexes>
            <lzc:index name="IDX_Customer_Address2Country" alias="address2country" accessor="Address2Country" object="PicklistItem" type="Foreign" constraintname="FK_Customer_Address2Country" cascade-delete="False" />
          </lzc:indexes>
        </lzc:field>
        <lzc:field name="Address2ZipCode" alias="address2zipcode" autogenerate="False" type="Varchar" friendly-name="Address2ZipCode" readonly="False" required="False" size="10" tableonly="False" logical-name="Address2ZipCode" dbname="Address2ZipCode" dbtype="Varchar" />
        <lzc:field name="HomePhone" alias="homephone" autogenerate="False" type="Varchar" friendly-name="HomePhone" readonly="False" required="False" size="20" tableonly="False" logical-name="HomePhone" dbname="HomePhone" dbtype="Varchar" />
        <lzc:field name="WorkPhone" alias="workphone" autogenerate="False" type="Varchar" friendly-name="WorkPhone" readonly="False" required="False" size="20" tableonly="False" logical-name="WorkPhone" dbname="WorkPhone" dbtype="Varchar" />
        <lzc:field name="FaxNumber" alias="faxnumber" autogenerate="False" type="Varchar" friendly-name="FaxNumber" readonly="False" required="False" size="20" tableonly="False" logical-name="FaxNumber" dbname="FaxNumber" dbtype="Varchar" />
        <lzc:field name="Email" alias="email" autogenerate="False" type="Varchar" friendly-name="Email" readonly="False" required="False" size="255" tableonly="False" logical-name="Email" dbname="Email" dbtype="Varchar" />
      </lzc:fields>
      <lzc:methods>
        <lzc:method name="Create" object-name="Create" db-name="CustomerCreate" methodtype="Create" filename="CustomerCreate" return-result="False">
          <lzc:method-params>
            <lzc:method-param name="Id" dbname="Id" type="Int" required="True" direction="out" />
            <lzc:method-param name="NameFirst" dbname="NameFirst" type="Varchar" size="50" required="False" direction="in" />
            <lzc:method-param name="NameMiddle" dbname="NameMiddle" type="Varchar" size="50" required="False" direction="in" />
            <lzc:method-param name="NameLast" dbname="NameLast" type="Varchar" size="50" required="False" direction="in" />
            <lzc:method-param name="Suffix" dbname="Suffix" type="Varchar" size="10" required="False" direction="in" />
            <lzc:method-param name="Prefix" dbname="Prefix" type="Varchar" size="10" required="False" direction="in" />
            <lzc:method-param name="Industry" dbname="IndustryId" type="Int" required="False" direction="in" />
            <lzc:method-param name="OrganizationType" dbname="OrganizationTypeId" type="Int" required="False" direction="in" />
            <lzc:method-param name="AreaOfExpertise" dbname="AreaOfExpertiseId" type="Int" required="False" direction="in" />
            <lzc:method-param name="PrimaryAreaOfResponsibility" dbname="PrimaryAreaOfResponsibilityId" type="Int" required="False" direction="in" />
            <lzc:method-param name="Gender" dbname="Gender" type="Varchar" size="1" required="False" direction="in" />
            <lzc:method-param name="Ethnicity" dbname="EthnicityId" type="Int" required="False" direction="in" />
            <lzc:method-param name="SpanOfControl" dbname="SpanOfControlId" type="Int" required="False" direction="in" />
            <lzc:method-param name="TIMSSCode" dbname="TIMSSCode" type="Varchar" size="8" required="False" direction="in" />
            <lzc:method-param name="TestWindowId" dbname="TestWindowIdId" type="Int" required="False" direction="in" />
            <lzc:method-param name="TestStatus" dbname="TestStatusId" type="Int" required="True" direction="in" />
            <lzc:method-param name="WorkSubmissionStatus" dbname="WorkSubmissionStatusId" type="Int" required="False" direction="in" />
            <lzc:method-param name="SpecialAccomodations" dbname="SpecialAccomodations" type="Bit" required="True" direction="in" />
            <lzc:method-param name="YearsInWorkplace" dbname="YearsInWorkplace" type="Smallint" required="True" direction="in" />
            <lzc:method-param name="OrganizationDescription" dbname="OrganizationDescription" type="Text" required="False" direction="in" />
            <lzc:method-param name="Eligibility" dbname="EligibilityId" type="Int" required="False" direction="in" />
            <lzc:method-param name="DegreeAttained" dbname="DegreeAttainedId" type="Int" required="False" direction="in" />
            <lzc:method-param name="YearGraduated" dbname="YearGraduated" type="Smallint" required="False" direction="in" />
            <lzc:method-param name="CurrentStudent" dbname="CurrentStudent" type="Bit" required="True" direction="in" />
            <lzc:method-param name="HoldList" dbname="HoldListId" type="Int" required="False" direction="in" />
            <lzc:method-param name="CodeOfEthicsAcknowledgement" dbname="CodeOfEthicsAcknowledgement" type="Bit" required="True" direction="in" />
            <lzc:method-param name="ReleaseAgreement" dbname="ReleaseAgreement" type="Bit" required="True" direction="in" />
            <lzc:method-param name="FirstTimeTester" dbname="FirstTimeTester" type="Bit" required="True" direction="in" />
            <lzc:method-param name="ValidatedByAdmin" dbname="ValidatedByAdmin" type="Bit" required="True" direction="in" />
            <lzc:method-param name="Exported" dbname="Exported" type="Bit" required="True" direction="in" />
            <lzc:method-param name="TestVendorExportDate" dbname="TestVendorExportDate" type="DateTime" required="False" direction="in" />
            <lzc:method-param name="ExportOverride" dbname="ExportOverride" type="Bit" required="True" direction="in" />
            <lzc:method-param name="Address1Line1" dbname="Address1Line1" type="Varchar" size="100" required="False" direction="in" />
            <lzc:method-param name="Address1Line2" dbname="Address1Line2" type="Varchar" size="100" required="False" direction="in" />
            <lzc:method-param name="Address1Line3" dbname="Address1Line3" type="Varchar" size="100" required="False" direction="in" />
            <lzc:method-param name="Address1City" dbname="Address1City" type="Varchar" size="50" required="False" direction="in" />
            <lzc:method-param name="Address1State" dbname="Address1StateId" type="Int" required="False" direction="in" />
            <lzc:method-param name="Address1Country" dbname="Address1CountryId" type="Int" required="False" direction="in" />
            <lzc:method-param name="Address1ZipCode" dbname="Address1ZipCode" type="Varchar" size="10" required="False" direction="in" />
            <lzc:method-param name="Address2Line1" dbname="Address2Line1" type="Varchar" size="100" required="False" direction="in" />
            <lzc:method-param name="Address2Line2" dbname="Address2Line2" type="Varchar" size="100" required="False" direction="in" />
            <lzc:method-param name="Address2Line3" dbname="Address2Line3" type="Varchar" size="100" required="False" direction="in" />
            <lzc:method-param name="Address2City" dbname="Address2City" type="Varchar" size="50" required="False" direction="in" />
            <lzc:method-param name="Address2State" dbname="Address2StateId" type="Int" required="False" direction="in" />
            <lzc:method-param name="Address2Country" dbname="Address2CountryId" type="Int" required="False" direction="in" />
            <lzc:method-param name="Address2ZipCode" dbname="Address2ZipCode" type="Varchar" size="10" required="False" direction="in" />
            <lzc:method-param name="HomePhone" dbname="HomePhone" type="Varchar" size="20" required="False" direction="in" />
            <lzc:method-param name="WorkPhone" dbname="WorkPhone" type="Varchar" size="20" required="False" direction="in" />
            <lzc:method-param name="FaxNumber" dbname="FaxNumber" type="Varchar" size="20" required="False" direction="in" />
            <lzc:method-param name="Email" dbname="Email" type="Varchar" size="255" required="False" direction="in" />
          </lzc:method-params>
          <lzc:method-effects>
            <lzc:object-ref name="Customer" effecttype="Create" ref="Customer" alias="Customer" pkfield="Id" fkfield="Id">
              <lzc:fields>
                <lzc:method-effect field="Id" type="Identity" dbtype="Int" dbname="Id" param="Id" autogenerate="True" />
                <lzc:method-effect field="NameFirst" type="Varchar" dbtype="Varchar" dbname="NameFirst" param="NameFirst" autogenerate="False" />
                <lzc:method-effect field="NameMiddle" type="Varchar" dbtype="Varchar" dbname="NameMiddle" param="NameMiddle" autogenerate="False" />
                <lzc:method-effect field="NameLast" type="Varchar" dbtype="Varchar" dbname="NameLast" param="NameLast" autogenerate="False" />
                <lzc:method-effect field="Suffix" type="Varchar" dbtype="Varchar" dbname="Suffix" param="Suffix" autogenerate="False" />
                <lzc:method-effect field="Prefix" type="Varchar" dbtype="Varchar" dbname="Prefix" param="Prefix" autogenerate="False" />
                <lzc:method-effect field="Industry" type="Int" dbtype="Int" dbname="IndustryId" param="Industry" autogenerate="False" />
                <lzc:method-effect field="OrganizationType" type="Int" dbtype="Int" dbname="OrganizationTypeId" param="OrganizationType" autogenerate="False" />
                <lzc:method-effect field="AreaOfExpertise" type="Int" dbtype="Int" dbname="AreaOfExpertiseId" param="AreaOfExpertise" autogenerate="False" />
                <lzc:method-effect field="PrimaryAreaOfResponsibility" type="Int" dbtype="Int" dbname="PrimaryAreaOfResponsibilityId" param="PrimaryAreaOfResponsibility" autogenerate="False" />
                <lzc:method-effect field="Gender" type="Varchar" dbtype="Varchar" dbname="Gender" param="Gender" autogenerate="False" />
                <lzc:method-effect field="Ethnicity" type="Int" dbtype="Int" dbname="EthnicityId" param="Ethnicity" autogenerate="False" />
                <lzc:method-effect field="SpanOfControl" type="Int" dbtype="Int" dbname="SpanOfControlId" param="SpanOfControl" autogenerate="False" />
                <lzc:method-effect field="TIMSSCode" type="Varchar" dbtype="Varchar" dbname="TIMSSCode" param="TIMSSCode" autogenerate="False" />
                <lzc:method-effect field="TestWindowId" type="Int" dbtype="Int" dbname="TestWindowIdId" param="TestWindowId" autogenerate="False" />
                <lzc:method-effect field="TestStatus" type="Int" dbtype="Int" dbname="TestStatusId" param="TestStatus" autogenerate="False" />
                <lzc:method-effect field="WorkSubmissionStatus" type="Int" dbtype="Int" dbname="WorkSubmissionStatusId" param="WorkSubmissionStatus" autogenerate="False" />
                <lzc:method-effect field="SpecialAccomodations" type="Bit" dbtype="Bit" dbname="SpecialAccomodations" param="SpecialAccomodations" autogenerate="False" />
                <lzc:method-effect field="YearsInWorkplace" type="Smallint" dbtype="Smallint" dbname="YearsInWorkplace" param="YearsInWorkplace" autogenerate="False" />
                <lzc:method-effect field="OrganizationDescription" type="Text" dbtype="Text" dbname="OrganizationDescription" param="OrganizationDescription" autogenerate="False" />
                <lzc:method-effect field="Eligibility" type="Int" dbtype="Int" dbname="EligibilityId" param="Eligibility" autogenerate="False" />
                <lzc:method-effect field="DegreeAttained" type="Int" dbtype="Int" dbname="DegreeAttainedId" param="DegreeAttained" autogenerate="False" />
                <lzc:method-effect field="YearGraduated" type="Smallint" dbtype="Smallint" dbname="YearGraduated" param="YearGraduated" autogenerate="False" />
                <lzc:method-effect field="CurrentStudent" type="Bit" dbtype="Bit" dbname="CurrentStudent" param="CurrentStudent" autogenerate="False" />
                <lzc:method-effect field="HoldList" type="Int" dbtype="Int" dbname="HoldListId" param="HoldList" autogenerate="False" />
                <lzc:method-effect field="CodeOfEthicsAcknowledgement" type="Bit" dbtype="Bit" dbname="CodeOfEthicsAcknowledgement" param="CodeOfEthicsAcknowledgement" autogenerate="False" />
                <lzc:method-effect field="ReleaseAgreement" type="Bit" dbtype="Bit" dbname="ReleaseAgreement" param="ReleaseAgreement" autogenerate="False" />
                <lzc:method-effect field="FirstTimeTester" type="Bit" dbtype="Bit" dbname="FirstTimeTester" param="FirstTimeTester" autogenerate="False" />
                <lzc:method-effect field="ValidatedByAdmin" type="Bit" dbtype="Bit" dbname="ValidatedByAdmin" param="ValidatedByAdmin" autogenerate="False" />
                <lzc:method-effect field="Exported" type="Bit" dbtype="Bit" dbname="Exported" param="Exported" autogenerate="False" />
                <lzc:method-effect field="TestVendorExportDate" type="DateTime" dbtype="DateTime" dbname="TestVendorExportDate" param="TestVendorExportDate" autogenerate="False" />
                <lzc:method-effect field="ExportOverride" type="Bit" dbtype="Bit" dbname="ExportOverride" param="ExportOverride" autogenerate="False" />
                <lzc:method-effect field="Address1Line1" type="Varchar" dbtype="Varchar" dbname="Address1Line1" param="Address1Line1" autogenerate="False" />
                <lzc:method-effect field="Address1Line2" type="Varchar" dbtype="Varchar" dbname="Address1Line2" param="Address1Line2" autogenerate="False" />
                <lzc:method-effect field="Address1Line3" type="Varchar" dbtype="Varchar" dbname="Address1Line3" param="Address1Line3" autogenerate="False" />
                <lzc:method-effect field="Address1City" type="Varchar" dbtype="Varchar" dbname="Address1City" param="Address1City" autogenerate="False" />
                <lzc:method-effect field="Address1State" type="Int" dbtype="Int" dbname="Address1StateId" param="Address1State" autogenerate="False" />
                <lzc:method-effect field="Address1Country" type="Int" dbtype="Int" dbname="Address1CountryId" param="Address1Country" autogenerate="False" />
                <lzc:method-effect field="Address1ZipCode" type="Varchar" dbtype="Varchar" dbname="Address1ZipCode" param="Address1ZipCode" autogenerate="False" />
                <lzc:method-effect field="Address2Line1" type="Varchar" dbtype="Varchar" dbname="Address2Line1" param="Address2Line1" autogenerate="False" />
                <lzc:method-effect field="Address2Line2" type="Varchar" dbtype="Varchar" dbname="Address2Line2" param="Address2Line2" autogenerate="False" />
                <lzc:method-effect field="Address2Line3" type="Varchar" dbtype="Varchar" dbname="Address2Line3" param="Address2Line3" autogenerate="False" />
                <lzc:method-effect field="Address2City" type="Varchar" dbtype="Varchar" dbname="Address2City" param="Address2City" autogenerate="False" />
                <lzc:method-effect field="Address2State" type="Int" dbtype="Int" dbname="Address2StateId" param="Address2State" autogenerate="False" />
                <lzc:method-effect field="Address2Country" type="Int" dbtype="Int" dbname="Address2CountryId" param="Address2Country" autogenerate="False" />
                <lzc:method-effect field="Address2ZipCode" type="Varchar" dbtype="Varchar" dbname="Address2ZipCode" param="Address2ZipCode" autogenerate="False" />
                <lzc:method-effect field="HomePhone" type="Varchar" dbtype="Varchar" dbname="HomePhone" param="HomePhone" autogenerate="False" />
                <lzc:method-effect field="WorkPhone" type="Varchar" dbtype="Varchar" dbname="WorkPhone" param="WorkPhone" autogenerate="False" />
                <lzc:method-effect field="FaxNumber" type="Varchar" dbtype="Varchar" dbname="FaxNumber" param="FaxNumber" autogenerate="False" />
                <lzc:method-effect field="Email" type="Varchar" dbtype="Varchar" dbname="Email" param="Email" autogenerate="False" />
              </lzc:fields>
            </lzc:object-ref>
          </lzc:method-effects>
        </lzc:method>
        <lzc:method name="Update" object-name="Update" db-name="CustomerUpdate" methodtype="Update" filename="CustomerUpdate" return-result="False">
          <lzc:method-params>
            <lzc:method-param name="Id" dbname="Id" type="Int" required="True" direction="in" />
            <lzc:method-param name="NameFirst" dbname="NameFirst" type="Varchar" size="50" required="False" direction="in" />
            <lzc:method-param name="NameMiddle" dbname="NameMiddle" type="Varchar" size="50" required="False" direction="in" />
            <lzc:method-param name="NameLast" dbname="NameLast" type="Varchar" size="50" required="False" direction="in" />
            <lzc:method-param name="Suffix" dbname="Suffix" type="Varchar" size="10" required="False" direction="in" />
            <lzc:method-param name="Prefix" dbname="Prefix" type="Varchar" size="10" required="False" direction="in" />
            <lzc:method-param name="Industry" dbname="IndustryId" type="Int" required="False" direction="in" />
            <lzc:method-param name="OrganizationType" dbname="OrganizationTypeId" type="Int" required="False" direction="in" />
            <lzc:method-param name="AreaOfExpertise" dbname="AreaOfExpertiseId" type="Int" required="False" direction="in" />
            <lzc:method-param name="PrimaryAreaOfResponsibility" dbname="PrimaryAreaOfResponsibilityId" type="Int" required="False" direction="in" />
            <lzc:method-param name="Gender" dbname="Gender" type="Varchar" size="1" required="False" direction="in" />
            <lzc:method-param name="Ethnicity" dbname="EthnicityId" type="Int" required="False" direction="in" />
            <lzc:method-param name="SpanOfControl" dbname="SpanOfControlId" type="Int" required="False" direction="in" />
            <lzc:method-param name="TIMSSCode" dbname="TIMSSCode" type="Varchar" size="8" required="False" direction="in" />
            <lzc:method-param name="TestWindowId" dbname="TestWindowIdId" type="Int" required="False" direction="in" />
            <lzc:method-param name="TestStatus" dbname="TestStatusId" type="Int" required="True" direction="in" />
            <lzc:method-param name="WorkSubmissionStatus" dbname="WorkSubmissionStatusId" type="Int" required="False" direction="in" />
            <lzc:method-param name="SpecialAccomodations" dbname="SpecialAccomodations" type="Bit" required="True" direction="in" />
            <lzc:method-param name="YearsInWorkplace" dbname="YearsInWorkplace" type="Smallint" required="True" direction="in" />
            <lzc:method-param name="OrganizationDescription" dbname="OrganizationDescription" type="Text" required="False" direction="in" />
            <lzc:method-param name="Eligibility" dbname="EligibilityId" type="Int" required="False" direction="in" />
            <lzc:method-param name="DegreeAttained" dbname="DegreeAttainedId" type="Int" required="False" direction="in" />
            <lzc:method-param name="YearGraduated" dbname="YearGraduated" type="Smallint" required="False" direction="in" />
            <lzc:method-param name="CurrentStudent" dbname="CurrentStudent" type="Bit" required="True" direction="in" />
            <lzc:method-param name="HoldList" dbname="HoldListId" type="Int" required="False" direction="in" />
            <lzc:method-param name="CodeOfEthicsAcknowledgement" dbname="CodeOfEthicsAcknowledgement" type="Bit" required="True" direction="in" />
            <lzc:method-param name="ReleaseAgreement" dbname="ReleaseAgreement" type="Bit" required="True" direction="in" />
            <lzc:method-param name="FirstTimeTester" dbname="FirstTimeTester" type="Bit" required="True" direction="in" />
            <lzc:method-param name="ValidatedByAdmin" dbname="ValidatedByAdmin" type="Bit" required="True" direction="in" />
            <lzc:method-param name="Exported" dbname="Exported" type="Bit" required="True" direction="in" />
            <lzc:method-param name="TestVendorExportDate" dbname="TestVendorExportDate" type="DateTime" required="False" direction="in" />
            <lzc:method-param name="ExportOverride" dbname="ExportOverride" type="Bit" required="True" direction="in" />
            <lzc:method-param name="Address1Line1" dbname="Address1Line1" type="Varchar" size="100" required="False" direction="in" />
            <lzc:method-param name="Address1Line2" dbname="Address1Line2" type="Varchar" size="100" required="False" direction="in" />
            <lzc:method-param name="Address1Line3" dbname="Address1Line3" type="Varchar" size="100" required="False" direction="in" />
            <lzc:method-param name="Address1City" dbname="Address1City" type="Varchar" size="50" required="False" direction="in" />
            <lzc:method-param name="Address1State" dbname="Address1StateId" type="Int" required="False" direction="in" />
            <lzc:method-param name="Address1Country" dbname="Address1CountryId" type="Int" required="False" direction="in" />
            <lzc:method-param name="Address1ZipCode" dbname="Address1ZipCode" type="Varchar" size="10" required="False" direction="in" />
            <lzc:method-param name="Address2Line1" dbname="Address2Line1" type="Varchar" size="100" required="False" direction="in" />
            <lzc:method-param name="Address2Line2" dbname="Address2Line2" type="Varchar" size="100" required="False" direction="in" />
            <lzc:method-param name="Address2Line3" dbname="Address2Line3" type="Varchar" size="100" required="False" direction="in" />
            <lzc:method-param name="Address2City" dbname="Address2City" type="Varchar" size="50" required="False" direction="in" />
            <lzc:method-param name="Address2State" dbname="Address2StateId" type="Int" required="False" direction="in" />
            <lzc:method-param name="Address2Country" dbname="Address2CountryId" type="Int" required="False" direction="in" />
            <lzc:method-param name="Address2ZipCode" dbname="Address2ZipCode" type="Varchar" size="10" required="False" direction="in" />
            <lzc:method-param name="HomePhone" dbname="HomePhone" type="Varchar" size="20" required="False" direction="in" />
            <lzc:method-param name="WorkPhone" dbname="WorkPhone" type="Varchar" size="20" required="False" direction="in" />
            <lzc:method-param name="FaxNumber" dbname="FaxNumber" type="Varchar" size="20" required="False" direction="in" />
            <lzc:method-param name="Email" dbname="Email" type="Varchar" size="255" required="False" direction="in" />
          </lzc:method-params>
          <lzc:method-effects>
            <lzc:object-ref name="Customer" effecttype="Update" ref="Customer" alias="Customer" pkfield="Id" fkfield="Id">
              <lzc:method-filters>
                <lzc:method-filter field="Id" param="Id" />
              </lzc:method-filters>
              <lzc:fields>
                <lzc:method-effect field="NameFirst" type="Varchar" dbtype="Varchar" dbname="NameFirst" param="NameFirst" autogenerate="False" />
                <lzc:method-effect field="NameMiddle" type="Varchar" dbtype="Varchar" dbname="NameMiddle" param="NameMiddle" autogenerate="False" />
                <lzc:method-effect field="NameLast" type="Varchar" dbtype="Varchar" dbname="NameLast" param="NameLast" autogenerate="False" />
                <lzc:method-effect field="Suffix" type="Varchar" dbtype="Varchar" dbname="Suffix" param="Suffix" autogenerate="False" />
                <lzc:method-effect field="Prefix" type="Varchar" dbtype="Varchar" dbname="Prefix" param="Prefix" autogenerate="False" />
                <lzc:method-effect field="Industry" type="Int" dbtype="Int" dbname="IndustryId" param="Industry" autogenerate="False" />
                <lzc:method-effect field="OrganizationType" type="Int" dbtype="Int" dbname="OrganizationTypeId" param="OrganizationType" autogenerate="False" />
                <lzc:method-effect field="AreaOfExpertise" type="Int" dbtype="Int" dbname="AreaOfExpertiseId" param="AreaOfExpertise" autogenerate="False" />
                <lzc:method-effect field="PrimaryAreaOfResponsibility" type="Int" dbtype="Int" dbname="PrimaryAreaOfResponsibilityId" param="PrimaryAreaOfResponsibility" autogenerate="False" />
                <lzc:method-effect field="Gender" type="Varchar" dbtype="Varchar" dbname="Gender" param="Gender" autogenerate="False" />
                <lzc:method-effect field="Ethnicity" type="Int" dbtype="Int" dbname="EthnicityId" param="Ethnicity" autogenerate="False" />
                <lzc:method-effect field="SpanOfControl" type="Int" dbtype="Int" dbname="SpanOfControlId" param="SpanOfControl" autogenerate="False" />
                <lzc:method-effect field="TIMSSCode" type="Varchar" dbtype="Varchar" dbname="TIMSSCode" param="TIMSSCode" autogenerate="False" />
                <lzc:method-effect field="TestWindowId" type="Int" dbtype="Int" dbname="TestWindowIdId" param="TestWindowId" autogenerate="False" />
                <lzc:method-effect field="TestStatus" type="Int" dbtype="Int" dbname="TestStatusId" param="TestStatus" autogenerate="False" />
                <lzc:method-effect field="WorkSubmissionStatus" type="Int" dbtype="Int" dbname="WorkSubmissionStatusId" param="WorkSubmissionStatus" autogenerate="False" />
                <lzc:method-effect field="SpecialAccomodations" type="Bit" dbtype="Bit" dbname="SpecialAccomodations" param="SpecialAccomodations" autogenerate="False" />
                <lzc:method-effect field="YearsInWorkplace" type="Smallint" dbtype="Smallint" dbname="YearsInWorkplace" param="YearsInWorkplace" autogenerate="False" />
                <lzc:method-effect field="OrganizationDescription" type="Text" dbtype="Text" dbname="OrganizationDescription" param="OrganizationDescription" autogenerate="False" />
                <lzc:method-effect field="Eligibility" type="Int" dbtype="Int" dbname="EligibilityId" param="Eligibility" autogenerate="False" />
                <lzc:method-effect field="DegreeAttained" type="Int" dbtype="Int" dbname="DegreeAttainedId" param="DegreeAttained" autogenerate="False" />
                <lzc:method-effect field="YearGraduated" type="Smallint" dbtype="Smallint" dbname="YearGraduated" param="YearGraduated" autogenerate="False" />
                <lzc:method-effect field="CurrentStudent" type="Bit" dbtype="Bit" dbname="CurrentStudent" param="CurrentStudent" autogenerate="False" />
                <lzc:method-effect field="HoldList" type="Int" dbtype="Int" dbname="HoldListId" param="HoldList" autogenerate="False" />
                <lzc:method-effect field="CodeOfEthicsAcknowledgement" type="Bit" dbtype="Bit" dbname="CodeOfEthicsAcknowledgement" param="CodeOfEthicsAcknowledgement" autogenerate="False" />
                <lzc:method-effect field="ReleaseAgreement" type="Bit" dbtype="Bit" dbname="ReleaseAgreement" param="ReleaseAgreement" autogenerate="False" />
                <lzc:method-effect field="FirstTimeTester" type="Bit" dbtype="Bit" dbname="FirstTimeTester" param="FirstTimeTester" autogenerate="False" />
                <lzc:method-effect field="ValidatedByAdmin" type="Bit" dbtype="Bit" dbname="ValidatedByAdmin" param="ValidatedByAdmin" autogenerate="False" />
                <lzc:method-effect field="Exported" type="Bit" dbtype="Bit" dbname="Exported" param="Exported" autogenerate="False" />
                <lzc:method-effect field="TestVendorExportDate" type="DateTime" dbtype="DateTime" dbname="TestVendorExportDate" param="TestVendorExportDate" autogenerate="False" />
                <lzc:method-effect field="ExportOverride" type="Bit" dbtype="Bit" dbname="ExportOverride" param="ExportOverride" autogenerate="False" />
                <lzc:method-effect field="Address1Line1" type="Varchar" dbtype="Varchar" dbname="Address1Line1" param="Address1Line1" autogenerate="False" />
                <lzc:method-effect field="Address1Line2" type="Varchar" dbtype="Varchar" dbname="Address1Line2" param="Address1Line2" autogenerate="False" />
                <lzc:method-effect field="Address1Line3" type="Varchar" dbtype="Varchar" dbname="Address1Line3" param="Address1Line3" autogenerate="False" />
                <lzc:method-effect field="Address1City" type="Varchar" dbtype="Varchar" dbname="Address1City" param="Address1City" autogenerate="False" />
                <lzc:method-effect field="Address1State" type="Int" dbtype="Int" dbname="Address1StateId" param="Address1State" autogenerate="False" />
                <lzc:method-effect field="Address1Country" type="Int" dbtype="Int" dbname="Address1CountryId" param="Address1Country" autogenerate="False" />
                <lzc:method-effect field="Address1ZipCode" type="Varchar" dbtype="Varchar" dbname="Address1ZipCode" param="Address1ZipCode" autogenerate="False" />
                <lzc:method-effect field="Address2Line1" type="Varchar" dbtype="Varchar" dbname="Address2Line1" param="Address2Line1" autogenerate="False" />
                <lzc:method-effect field="Address2Line2" type="Varchar" dbtype="Varchar" dbname="Address2Line2" param="Address2Line2" autogenerate="False" />
                <lzc:method-effect field="Address2Line3" type="Varchar" dbtype="Varchar" dbname="Address2Line3" param="Address2Line3" autogenerate="False" />
                <lzc:method-effect field="Address2City" type="Varchar" dbtype="Varchar" dbname="Address2City" param="Address2City" autogenerate="False" />
                <lzc:method-effect field="Address2State" type="Int" dbtype="Int" dbname="Address2StateId" param="Address2State" autogenerate="False" />
                <lzc:method-effect field="Address2Country" type="Int" dbtype="Int" dbname="Address2CountryId" param="Address2Country" autogenerate="False" />
                <lzc:method-effect field="Address2ZipCode" type="Varchar" dbtype="Varchar" dbname="Address2ZipCode" param="Address2ZipCode" autogenerate="False" />
                <lzc:method-effect field="HomePhone" type="Varchar" dbtype="Varchar" dbname="HomePhone" param="HomePhone" autogenerate="False" />
                <lzc:method-effect field="WorkPhone" type="Varchar" dbtype="Varchar" dbname="WorkPhone" param="WorkPhone" autogenerate="False" />
                <lzc:method-effect field="FaxNumber" type="Varchar" dbtype="Varchar" dbname="FaxNumber" param="FaxNumber" autogenerate="False" />
                <lzc:method-effect field="Email" type="Varchar" dbtype="Varchar" dbname="Email" param="Email" autogenerate="False" />
              </lzc:fields>
            </lzc:object-ref>
          </lzc:method-effects>
        </lzc:method>
        <lzc:method name="Get" object-name="Get" db-name="CustomerGet" methodtype="Get" filename="CustomerGet" return-result="True">
          <lzc:method-params>
            <lzc:method-param name="Id" dbname="Id" type="Int" required="True" direction="in" />
          </lzc:method-params>
          <lzc:method-filters>
            <lzc:method-filter field="Id" param="Id" />
          </lzc:method-filters>
          <lzc:method-results>
            <lzc:object-ref name="Customer" ref="Customer" alias="Customer" pkfield="Id" fkfield="Id" required="False">
              <lzc:fields>
                <lzc:method-result field="Id" alias="id" type="Int" dbname="Id" />
                <lzc:method-result field="NameFirst" alias="namefirst" type="Varchar" dbname="NameFirst" size="50" />
                <lzc:method-result field="NameMiddle" alias="namemiddle" type="Varchar" dbname="NameMiddle" size="50" />
                <lzc:method-result field="NameLast" alias="namelast" type="Varchar" dbname="NameLast" size="50" />
                <lzc:method-result field="Suffix" alias="suffix" type="Varchar" dbname="Suffix" size="10" />
                <lzc:method-result field="Prefix" alias="prefix" type="Varchar" dbname="Prefix" size="10" />
                <lzc:method-result field="Industry" alias="industry" type="Int" dbname="IndustryId" />
                <lzc:method-result field="OrganizationType" alias="organizationtype" type="Int" dbname="OrganizationTypeId" />
                <lzc:method-result field="AreaOfExpertise" alias="areaofexpertise" type="Int" dbname="AreaOfExpertiseId" />
                <lzc:method-result field="PrimaryAreaOfResponsibility" alias="primaryareaofresponsibility" type="Int" dbname="PrimaryAreaOfResponsibilityId" />
                <lzc:method-result field="Gender" alias="gender" type="Varchar" dbname="Gender" size="1" />
                <lzc:method-result field="Ethnicity" alias="ethnicity" type="Int" dbname="EthnicityId" />
                <lzc:method-result field="SpanOfControl" alias="spanofcontrol" type="Int" dbname="SpanOfControlId" />
                <lzc:method-result field="TIMSSCode" alias="timsscode" type="Varchar" dbname="TIMSSCode" size="8" />
                <lzc:method-result field="TestWindowId" alias="testwindowid" type="Int" dbname="TestWindowIdId" />
                <lzc:method-result field="TestStatus" alias="teststatus" type="Int" dbname="TestStatusId" />
                <lzc:method-result field="WorkSubmissionStatus" alias="worksubmissionstatus" type="Int" dbname="WorkSubmissionStatusId" />
                <lzc:method-result field="SpecialAccomodations" alias="specialaccomodations" type="Bit" dbname="SpecialAccomodations" />
                <lzc:method-result field="YearsInWorkplace" alias="yearsinworkplace" type="Smallint" dbname="YearsInWorkplace" />
                <lzc:method-result field="OrganizationDescription" alias="organizationdescription" type="Text" dbname="OrganizationDescription" />
                <lzc:method-result field="Eligibility" alias="eligibility" type="Int" dbname="EligibilityId" />
                <lzc:method-result field="DegreeAttained" alias="degreeattained" type="Int" dbname="DegreeAttainedId" />
                <lzc:method-result field="YearGraduated" alias="yeargraduated" type="Smallint" dbname="YearGraduated" />
                <lzc:method-result field="CurrentStudent" alias="currentstudent" type="Bit" dbname="CurrentStudent" />
                <lzc:method-result field="HoldList" alias="holdlist" type="Int" dbname="HoldListId" />
                <lzc:method-result field="CodeOfEthicsAcknowledgement" alias="codeofethicsacknowledgement" type="Bit" dbname="CodeOfEthicsAcknowledgement" />
                <lzc:method-result field="ReleaseAgreement" alias="releaseagreement" type="Bit" dbname="ReleaseAgreement" />
                <lzc:method-result field="FirstTimeTester" alias="firsttimetester" type="Bit" dbname="FirstTimeTester" />
                <lzc:method-result field="ValidatedByAdmin" alias="validatedbyadmin" type="Bit" dbname="ValidatedByAdmin" />
                <lzc:method-result field="Exported" alias="exported" type="Bit" dbname="Exported" />
                <lzc:method-result field="TestVendorExportDate" alias="testvendorexportdate" type="DateTime" dbname="TestVendorExportDate" />
                <lzc:method-result field="ExportOverride" alias="exportoverride" type="Bit" dbname="ExportOverride" />
                <lzc:method-result field="Address1Line1" alias="address1line1" type="Varchar" dbname="Address1Line1" size="100" />
                <lzc:method-result field="Address1Line2" alias="address1line2" type="Varchar" dbname="Address1Line2" size="100" />
                <lzc:method-result field="Address1Line3" alias="address1line3" type="Varchar" dbname="Address1Line3" size="100" />
                <lzc:method-result field="Address1City" alias="address1city" type="Varchar" dbname="Address1City" size="50" />
                <lzc:method-result field="Address1State" alias="address1state" type="Int" dbname="Address1StateId" />
                <lzc:method-result field="Address1Country" alias="address1country" type="Int" dbname="Address1CountryId" />
                <lzc:method-result field="Address1ZipCode" alias="address1zipcode" type="Varchar" dbname="Address1ZipCode" size="10" />
                <lzc:method-result field="Address2Line1" alias="address2line1" type="Varchar" dbname="Address2Line1" size="100" />
                <lzc:method-result field="Address2Line2" alias="address2line2" type="Varchar" dbname="Address2Line2" size="100" />
                <lzc:method-result field="Address2Line3" alias="address2line3" type="Varchar" dbname="Address2Line3" size="100" />
                <lzc:method-result field="Address2City" alias="address2city" type="Varchar" dbname="Address2City" size="50" />
                <lzc:method-result field="Address2State" alias="address2state" type="Int" dbname="Address2StateId" />
                <lzc:method-result field="Address2Country" alias="address2country" type="Int" dbname="Address2CountryId" />
                <lzc:method-result field="Address2ZipCode" alias="address2zipcode" type="Varchar" dbname="Address2ZipCode" size="10" />
                <lzc:method-result field="HomePhone" alias="homephone" type="Varchar" dbname="HomePhone" size="20" />
                <lzc:method-result field="WorkPhone" alias="workphone" type="Varchar" dbname="WorkPhone" size="20" />
                <lzc:method-result field="FaxNumber" alias="faxnumber" type="Varchar" dbname="FaxNumber" size="20" />
                <lzc:method-result field="Email" alias="email" type="Varchar" dbname="Email" size="255" />
              </lzc:fields>
            </lzc:object-ref>
          </lzc:method-results>
        </lzc:method>
        <lzc:method name="List" object-name="List" db-name="CustomerList" methodtype="List" filename="CustomerList" return-result="True">
          <lzc:method-results>
            <lzc:object-ref name="Customer" ref="Customer" alias="Customer" fkfield="Id" required="True">
              <lzc:fields>
                <lzc:method-result field="Id" alias="Id" type="Int" dbname="Id" />
                <lzc:method-result field="NameFirst" alias="NameFirst" type="Varchar" dbname="NameFirst" size="50" />
                <lzc:method-result field="NameMiddle" alias="NameMiddle" type="Varchar" dbname="NameMiddle" size="50" />
                <lzc:method-result field="NameLast" alias="NameLast" type="Varchar" dbname="NameLast" size="50" />
                <lzc:method-result field="Suffix" alias="Suffix" type="Varchar" dbname="Suffix" size="10" />
                <lzc:method-result field="Prefix" alias="Prefix" type="Varchar" dbname="Prefix" size="10" />
                <lzc:method-result field="Industry" alias="IndustryId" type="Int" dbname="IndustryId" />
                <lzc:method-result field="OrganizationType" alias="OrganizationTypeId" type="Int" dbname="OrganizationTypeId" />
                <lzc:method-result field="AreaOfExpertise" alias="AreaOfExpertiseId" type="Int" dbname="AreaOfExpertiseId" />
                <lzc:method-result field="PrimaryAreaOfResponsibility" alias="PrimaryAreaOfResponsibilityId" type="Int" dbname="PrimaryAreaOfResponsibilityId" />
                <lzc:method-result field="Gender" alias="Gender" type="Varchar" dbname="Gender" size="1" />
                <lzc:method-result field="Ethnicity" alias="EthnicityId" type="Int" dbname="EthnicityId" />
                <lzc:method-result field="SpanOfControl" alias="SpanOfControlId" type="Int" dbname="SpanOfControlId" />
                <lzc:method-result field="TIMSSCode" alias="TIMSSCode" type="Varchar" dbname="TIMSSCode" size="8" />
                <lzc:method-result field="TestWindowId" alias="TestWindowIdId" type="Int" dbname="TestWindowIdId" />
                <lzc:method-result field="TestStatus" alias="TestStatusId" type="Int" dbname="TestStatusId" />
                <lzc:method-result field="WorkSubmissionStatus" alias="WorkSubmissionStatusId" type="Int" dbname="WorkSubmissionStatusId" />
                <lzc:method-result field="SpecialAccomodations" alias="SpecialAccomodations" type="Bit" dbname="SpecialAccomodations" />
                <lzc:method-result field="YearsInWorkplace" alias="YearsInWorkplace" type="Smallint" dbname="YearsInWorkplace" />
                <lzc:method-result field="OrganizationDescription" alias="OrganizationDescription" type="Text" dbname="OrganizationDescription" />
                <lzc:method-result field="Eligibility" alias="EligibilityId" type="Int" dbname="EligibilityId" />
                <lzc:method-result field="DegreeAttained" alias="DegreeAttainedId" type="Int" dbname="DegreeAttainedId" />
                <lzc:method-result field="YearGraduated" alias="YearGraduated" type="Smallint" dbname="YearGraduated" />
                <lzc:method-result field="CurrentStudent" alias="CurrentStudent" type="Bit" dbname="CurrentStudent" />
                <lzc:method-result field="HoldList" alias="HoldListId" type="Int" dbname="HoldListId" />
                <lzc:method-result field="CodeOfEthicsAcknowledgement" alias="CodeOfEthicsAcknowledgement" type="Bit" dbname="CodeOfEthicsAcknowledgement" />
                <lzc:method-result field="ReleaseAgreement" alias="ReleaseAgreement" type="Bit" dbname="ReleaseAgreement" />
                <lzc:method-result field="FirstTimeTester" alias="FirstTimeTester" type="Bit" dbname="FirstTimeTester" />
                <lzc:method-result field="ValidatedByAdmin" alias="ValidatedByAdmin" type="Bit" dbname="ValidatedByAdmin" />
                <lzc:method-result field="Exported" alias="Exported" type="Bit" dbname="Exported" />
                <lzc:method-result field="TestVendorExportDate" alias="TestVendorExportDate" type="DateTime" dbname="TestVendorExportDate" />
                <lzc:method-result field="ExportOverride" alias="ExportOverride" type="Bit" dbname="ExportOverride" />
                <lzc:method-result field="Address1Line1" alias="Address1Line1" type="Varchar" dbname="Address1Line1" size="100" />
                <lzc:method-result field="Address1Line2" alias="Address1Line2" type="Varchar" dbname="Address1Line2" size="100" />
                <lzc:method-result field="Address1Line3" alias="Address1Line3" type="Varchar" dbname="Address1Line3" size="100" />
                <lzc:method-result field="Address1City" alias="Address1City" type="Varchar" dbname="Address1City" size="50" />
                <lzc:method-result field="Address1State" alias="Address1StateId" type="Int" dbname="Address1StateId" />
                <lzc:method-result field="Address1Country" alias="Address1CountryId" type="Int" dbname="Address1CountryId" />
                <lzc:method-result field="Address1ZipCode" alias="Address1ZipCode" type="Varchar" dbname="Address1ZipCode" size="10" />
                <lzc:method-result field="Address2Line1" alias="Address2Line1" type="Varchar" dbname="Address2Line1" size="100" />
                <lzc:method-result field="Address2Line2" alias="Address2Line2" type="Varchar" dbname="Address2Line2" size="100" />
                <lzc:method-result field="Address2Line3" alias="Address2Line3" type="Varchar" dbname="Address2Line3" size="100" />
                <lzc:method-result field="Address2City" alias="Address2City" type="Varchar" dbname="Address2City" size="50" />
                <lzc:method-result field="Address2State" alias="Address2StateId" type="Int" dbname="Address2StateId" />
                <lzc:method-result field="Address2Country" alias="Address2CountryId" type="Int" dbname="Address2CountryId" />
                <lzc:method-result field="Address2ZipCode" alias="Address2ZipCode" type="Varchar" dbname="Address2ZipCode" size="10" />
                <lzc:method-result field="HomePhone" alias="HomePhone" type="Varchar" dbname="HomePhone" size="20" />
                <lzc:method-result field="WorkPhone" alias="WorkPhone" type="Varchar" dbname="WorkPhone" size="20" />
                <lzc:method-result field="FaxNumber" alias="FaxNumber" type="Varchar" dbname="FaxNumber" size="20" />
                <lzc:method-result field="Email" alias="Email" type="Varchar" dbname="Email" size="255" />
              </lzc:fields>
            </lzc:object-ref>
            <lzc:object-ref name="Industry" ref="PicklistItem" alias="industry" pkfield="Id" fkfield="IndustryId" required="False">
              <lzc:fields>
                <lzc:method-result name="Title" field="Title" alias="IndustryTitle" type="Varchar" dbname="Title" size="255" />
              </lzc:fields>
            </lzc:object-ref>
            <lzc:object-ref name="OrganizationType" ref="PicklistItem" alias="organizationtype" pkfield="Id" fkfield="OrganizationTypeId" required="False">
              <lzc:fields>
                <lzc:method-result name="Title" field="Title" alias="OrganizationTypeTitle" type="Varchar" dbname="Title" size="255" />
              </lzc:fields>
            </lzc:object-ref>
            <lzc:object-ref name="AreaOfExpertise" ref="PicklistItem" alias="areaofexpertise" pkfield="Id" fkfield="AreaOfExpertiseId" required="False">
              <lzc:fields>
                <lzc:method-result name="Title" field="Title" alias="AreaOfExpertiseTitle" type="Varchar" dbname="Title" size="255" />
              </lzc:fields>
            </lzc:object-ref>
            <lzc:object-ref name="PrimaryAreaOfResponsibility" ref="PicklistItem" alias="primaryareaofresponsibility" pkfield="Id" fkfield="PrimaryAreaOfResponsibilityId" required="False">
              <lzc:fields>
                <lzc:method-result name="Title" field="Title" alias="PrimaryAreaOfResponsibilityTitle" type="Varchar" dbname="Title" size="255" />
              </lzc:fields>
            </lzc:object-ref>
            <lzc:object-ref name="Ethnicity" ref="PicklistItem" alias="ethnicity" pkfield="Id" fkfield="EthnicityId" required="False">
              <lzc:fields>
                <lzc:method-result name="Title" field="Title" alias="EthnicityTitle" type="Varchar" dbname="Title" size="255" />
              </lzc:fields>
            </lzc:object-ref>
            <lzc:object-ref name="SpanOfControl" ref="PicklistItem" alias="spanofcontrol" pkfield="Id" fkfield="SpanOfControlId" required="False">
              <lzc:fields>
                <lzc:method-result name="Title" field="Title" alias="SpanOfControlTitle" type="Varchar" dbname="Title" size="255" />
              </lzc:fields>
            </lzc:object-ref>
            <lzc:object-ref name="TestWindowId" ref="TestWindow" alias="testwindowid" pkfield="Id" fkfield="TestWindowIdId" required="False">
              <lzc:fields>
                <lzc:method-result name="Name" field="Name" alias="TestWindowIdName" type="Varchar" dbname="Name" size="50" />
              </lzc:fields>
            </lzc:object-ref>
            <lzc:object-ref name="Eligibility" ref="PicklistItem" alias="eligibility" pkfield="Id" fkfield="EligibilityId" required="False">
              <lzc:fields>
                <lzc:method-result name="Title" field="Title" alias="EligibilityTitle" type="Varchar" dbname="Title" size="255" />
              </lzc:fields>
            </lzc:object-ref>
            <lzc:object-ref name="DegreeAttained" ref="PicklistItem" alias="degreeattained" pkfield="Id" fkfield="DegreeAttainedId" required="False">
              <lzc:fields>
                <lzc:method-result name="Title" field="Title" alias="DegreeAttainedTitle" type="Varchar" dbname="Title" size="255" />
              </lzc:fields>
            </lzc:object-ref>
            <lzc:object-ref name="HoldList" ref="PicklistItem" alias="holdlist" pkfield="Id" fkfield="HoldListId" required="False">
              <lzc:fields>
                <lzc:method-result name="Title" field="Title" alias="HoldListTitle" type="Varchar" dbname="Title" size="255" />
              </lzc:fields>
            </lzc:object-ref>
            <lzc:object-ref name="Address1State" ref="PicklistItem" alias="address1state" pkfield="Id" fkfield="Address1StateId" required="False">
              <lzc:fields>
                <lzc:method-result name="Title" field="Title" alias="Address1StateTitle" type="Varchar" dbname="Title" size="255" />
              </lzc:fields>
            </lzc:object-ref>
            <lzc:object-ref name="Address1Country" ref="PicklistItem" alias="address1country" pkfield="Id" fkfield="Address1CountryId" required="False">
              <lzc:fields>
                <lzc:method-result name="Title" field="Title" alias="Address1CountryTitle" type="Varchar" dbname="Title" size="255" />
              </lzc:fields>
            </lzc:object-ref>
            <lzc:object-ref name="Address2State" ref="PicklistItem" alias="address2state" pkfield="Id" fkfield="Address2StateId" required="False">
              <lzc:fields>
                <lzc:method-result name="Title" field="Title" alias="Address2StateTitle" type="Varchar" dbname="Title" size="255" />
              </lzc:fields>
            </lzc:object-ref>
            <lzc:object-ref name="Address2Country" ref="PicklistItem" alias="address2country" pkfield="Id" fkfield="Address2CountryId" required="False">
              <lzc:fields>
                <lzc:method-result name="Title" field="Title" alias="Address2CountryTitle" type="Varchar" dbname="Title" size="255" />
              </lzc:fields>
            </lzc:object-ref>
          </lzc:method-results>
        </lzc:method>
        <lzc:method name="List" object-name="List" db-name="CutomerListByTIMSSCode" methodtype="List" filename="CutomerListByTIMSSCode" return-result="True">
          <lzc:method-params>
            <lzc:method-param name="TIMSSCode" dbname="TIMSSCode" type="Varchar" size="8" required="True" direction="in" />
          </lzc:method-params>
          <lzc:method-filters>
            <lzc:method-filter field="TIMSSCode" param="TIMSSCode" />
          </lzc:method-filters>
          <lzc:method-results>
            <lzc:object-ref name="Customer" ref="Customer" alias="Customer" fkfield="Id" required="True">
              <lzc:fields>
                <lzc:method-result field="Id" alias="Id" type="Int" dbname="Id" />
                <lzc:method-result field="NameFirst" alias="NameFirst" type="Varchar" dbname="NameFirst" size="50" />
                <lzc:method-result field="NameMiddle" alias="NameMiddle" type="Varchar" dbname="NameMiddle" size="50" />
                <lzc:method-result field="NameLast" alias="NameLast" type="Varchar" dbname="NameLast" size="50" />
                <lzc:method-result field="Suffix" alias="Suffix" type="Varchar" dbname="Suffix" size="10" />
                <lzc:method-result field="Prefix" alias="Prefix" type="Varchar" dbname="Prefix" size="10" />
                <lzc:method-result field="Industry" alias="IndustryId" type="Int" dbname="IndustryId" />
                <lzc:method-result field="OrganizationType" alias="OrganizationTypeId" type="Int" dbname="OrganizationTypeId" />
                <lzc:method-result field="AreaOfExpertise" alias="AreaOfExpertiseId" type="Int" dbname="AreaOfExpertiseId" />
                <lzc:method-result field="PrimaryAreaOfResponsibility" alias="PrimaryAreaOfResponsibilityId" type="Int" dbname="PrimaryAreaOfResponsibilityId" />
                <lzc:method-result field="Gender" alias="Gender" type="Varchar" dbname="Gender" size="1" />
                <lzc:method-result field="Ethnicity" alias="EthnicityId" type="Int" dbname="EthnicityId" />
                <lzc:method-result field="SpanOfControl" alias="SpanOfControlId" type="Int" dbname="SpanOfControlId" />
                <lzc:method-result field="TIMSSCode" alias="TIMSSCode" type="Varchar" dbname="TIMSSCode" size="8" />
                <lzc:method-result field="TestWindowId" alias="TestWindowIdId" type="Int" dbname="TestWindowIdId" />
                <lzc:method-result field="TestStatus" alias="TestStatusId" type="Int" dbname="TestStatusId" />
                <lzc:method-result field="WorkSubmissionStatus" alias="WorkSubmissionStatusId" type="Int" dbname="WorkSubmissionStatusId" />
                <lzc:method-result field="SpecialAccomodations" alias="SpecialAccomodations" type="Bit" dbname="SpecialAccomodations" />
                <lzc:method-result field="YearsInWorkplace" alias="YearsInWorkplace" type="Smallint" dbname="YearsInWorkplace" />
                <lzc:method-result field="OrganizationDescription" alias="OrganizationDescription" type="Text" dbname="OrganizationDescription" />
                <lzc:method-result field="Eligibility" alias="EligibilityId" type="Int" dbname="EligibilityId" />
                <lzc:method-result field="DegreeAttained" alias="DegreeAttainedId" type="Int" dbname="DegreeAttainedId" />
                <lzc:method-result field="YearGraduated" alias="YearGraduated" type="Smallint" dbname="YearGraduated" />
                <lzc:method-result field="CurrentStudent" alias="CurrentStudent" type="Bit" dbname="CurrentStudent" />
                <lzc:method-result field="HoldList" alias="HoldListId" type="Int" dbname="HoldListId" />
                <lzc:method-result field="CodeOfEthicsAcknowledgement" alias="CodeOfEthicsAcknowledgement" type="Bit" dbname="CodeOfEthicsAcknowledgement" />
                <lzc:method-result field="ReleaseAgreement" alias="ReleaseAgreement" type="Bit" dbname="ReleaseAgreement" />
                <lzc:method-result field="FirstTimeTester" alias="FirstTimeTester" type="Bit" dbname="FirstTimeTester" />
                <lzc:method-result field="ValidatedByAdmin" alias="ValidatedByAdmin" type="Bit" dbname="ValidatedByAdmin" />
                <lzc:method-result field="Exported" alias="Exported" type="Bit" dbname="Exported" />
                <lzc:method-result field="TestVendorExportDate" alias="TestVendorExportDate" type="DateTime" dbname="TestVendorExportDate" />
                <lzc:method-result field="ExportOverride" alias="ExportOverride" type="Bit" dbname="ExportOverride" />
                <lzc:method-result field="Address1Line1" alias="Address1Line1" type="Varchar" dbname="Address1Line1" size="100" />
                <lzc:method-result field="Address1Line2" alias="Address1Line2" type="Varchar" dbname="Address1Line2" size="100" />
                <lzc:method-result field="Address1Line3" alias="Address1Line3" type="Varchar" dbname="Address1Line3" size="100" />
                <lzc:method-result field="Address1City" alias="Address1City" type="Varchar" dbname="Address1City" size="50" />
                <lzc:method-result field="Address1State" alias="Address1StateId" type="Int" dbname="Address1StateId" />
                <lzc:method-result field="Address1Country" alias="Address1CountryId" type="Int" dbname="Address1CountryId" />
                <lzc:method-result field="Address1ZipCode" alias="Address1ZipCode" type="Varchar" dbname="Address1ZipCode" size="10" />
                <lzc:method-result field="Address2Line1" alias="Address2Line1" type="Varchar" dbname="Address2Line1" size="100" />
                <lzc:method-result field="Address2Line2" alias="Address2Line2" type="Varchar" dbname="Address2Line2" size="100" />
                <lzc:method-result field="Address2Line3" alias="Address2Line3" type="Varchar" dbname="Address2Line3" size="100" />
                <lzc:method-result field="Address2City" alias="Address2City" type="Varchar" dbname="Address2City" size="50" />
                <lzc:method-result field="Address2State" alias="Address2StateId" type="Int" dbname="Address2StateId" />
                <lzc:method-result field="Address2Country" alias="Address2CountryId" type="Int" dbname="Address2CountryId" />
                <lzc:method-result field="Address2ZipCode" alias="Address2ZipCode" type="Varchar" dbname="Address2ZipCode" size="10" />
                <lzc:method-result field="HomePhone" alias="HomePhone" type="Varchar" dbname="HomePhone" size="20" />
                <lzc:method-result field="WorkPhone" alias="WorkPhone" type="Varchar" dbname="WorkPhone" size="20" />
                <lzc:method-result field="FaxNumber" alias="FaxNumber" type="Varchar" dbname="FaxNumber" size="20" />
                <lzc:method-result field="Email" alias="Email" type="Varchar" dbname="Email" size="255" />
              </lzc:fields>
            </lzc:object-ref>
            <lzc:object-ref name="Industry" ref="PicklistItem" alias="industry" pkfield="Id" fkfield="IndustryId" required="False">
              <lzc:fields>
                <lzc:method-result name="Title" field="Title" alias="IndustryTitle" type="Varchar" dbname="Title" size="255" />
              </lzc:fields>
            </lzc:object-ref>
            <lzc:object-ref name="OrganizationType" ref="PicklistItem" alias="organizationtype" pkfield="Id" fkfield="OrganizationTypeId" required="False">
              <lzc:fields>
                <lzc:method-result name="Title" field="Title" alias="OrganizationTypeTitle" type="Varchar" dbname="Title" size="255" />
              </lzc:fields>
            </lzc:object-ref>
            <lzc:object-ref name="AreaOfExpertise" ref="PicklistItem" alias="areaofexpertise" pkfield="Id" fkfield="AreaOfExpertiseId" required="False">
              <lzc:fields>
                <lzc:method-result name="Title" field="Title" alias="AreaOfExpertiseTitle" type="Varchar" dbname="Title" size="255" />
              </lzc:fields>
            </lzc:object-ref>
            <lzc:object-ref name="PrimaryAreaOfResponsibility" ref="PicklistItem" alias="primaryareaofresponsibility" pkfield="Id" fkfield="PrimaryAreaOfResponsibilityId" required="False">
              <lzc:fields>
                <lzc:method-result name="Title" field="Title" alias="PrimaryAreaOfResponsibilityTitle" type="Varchar" dbname="Title" size="255" />
              </lzc:fields>
            </lzc:object-ref>
            <lzc:object-ref name="Ethnicity" ref="PicklistItem" alias="ethnicity" pkfield="Id" fkfield="EthnicityId" required="False">
              <lzc:fields>
                <lzc:method-result name="Title" field="Title" alias="EthnicityTitle" type="Varchar" dbname="Title" size="255" />
              </lzc:fields>
            </lzc:object-ref>
            <lzc:object-ref name="SpanOfControl" ref="PicklistItem" alias="spanofcontrol" pkfield="Id" fkfield="SpanOfControlId" required="False">
              <lzc:fields>
                <lzc:method-result name="Title" field="Title" alias="SpanOfControlTitle" type="Varchar" dbname="Title" size="255" />
              </lzc:fields>
            </lzc:object-ref>
            <lzc:object-ref name="TestWindowId" ref="TestWindow" alias="testwindowid" pkfield="Id" fkfield="TestWindowIdId" required="False">
              <lzc:fields>
                <lzc:method-result name="Name" field="Name" alias="TestWindowIdName" type="Varchar" dbname="Name" size="50" />
              </lzc:fields>
            </lzc:object-ref>
            <lzc:object-ref name="Eligibility" ref="PicklistItem" alias="eligibility" pkfield="Id" fkfield="EligibilityId" required="False">
              <lzc:fields>
                <lzc:method-result name="Title" field="Title" alias="EligibilityTitle" type="Varchar" dbname="Title" size="255" />
              </lzc:fields>
            </lzc:object-ref>
            <lzc:object-ref name="DegreeAttained" ref="PicklistItem" alias="degreeattained" pkfield="Id" fkfield="DegreeAttainedId" required="False">
              <lzc:fields>
                <lzc:method-result name="Title" field="Title" alias="DegreeAttainedTitle" type="Varchar" dbname="Title" size="255" />
              </lzc:fields>
            </lzc:object-ref>
            <lzc:object-ref name="HoldList" ref="PicklistItem" alias="holdlist" pkfield="Id" fkfield="HoldListId" required="False">
              <lzc:fields>
                <lzc:method-result name="Title" field="Title" alias="HoldListTitle" type="Varchar" dbname="Title" size="255" />
              </lzc:fields>
            </lzc:object-ref>
            <lzc:object-ref name="Address1State" ref="PicklistItem" alias="address1state" pkfield="Id" fkfield="Address1StateId" required="False">
              <lzc:fields>
                <lzc:method-result name="Title" field="Title" alias="Address1StateTitle" type="Varchar" dbname="Title" size="255" />
              </lzc:fields>
            </lzc:object-ref>
            <lzc:object-ref name="Address1Country" ref="PicklistItem" alias="address1country" pkfield="Id" fkfield="Address1CountryId" required="False">
              <lzc:fields>
                <lzc:method-result name="Title" field="Title" alias="Address1CountryTitle" type="Varchar" dbname="Title" size="255" />
              </lzc:fields>
            </lzc:object-ref>
            <lzc:object-ref name="Address2State" ref="PicklistItem" alias="address2state" pkfield="Id" fkfield="Address2StateId" required="False">
              <lzc:fields>
                <lzc:method-result name="Title" field="Title" alias="Address2StateTitle" type="Varchar" dbname="Title" size="255" />
              </lzc:fields>
            </lzc:object-ref>
            <lzc:object-ref name="Address2Country" ref="PicklistItem" alias="address2country" pkfield="Id" fkfield="Address2CountryId" required="False">
              <lzc:fields>
                <lzc:method-result name="Title" field="Title" alias="Address2CountryTitle" type="Varchar" dbname="Title" size="255" />
              </lzc:fields>
            </lzc:object-ref>
          </lzc:method-results>
        </lzc:method>
        <lzc:method name="UpdateTestStatus" object-name="UpdateTestStatus" db-name="CustomerUpdateTestStatus" methodtype="Custom" filename="CustomerUpdateTestStatus" return-result="False">
          <lzc:method-params>
            <lzc:method-param name="Id" dbname="Id" type="Int" required="True" direction="in" />
            <lzc:method-param name="TestStatusId" dbname="TestStatusId" type="Int" required="True" direction="in" />
          </lzc:method-params>
        </lzc:method>
        <lzc:method name="UpdateExportStatus" object-name="UpdateExportStatus" db-name="CustomerUpdateExportStatus" methodtype="Custom" filename="CustomerUpdateExportStatus" return-result="False">
          <lzc:method-params>
            <lzc:method-param name="Id" dbname="Id" type="Int" required="True" direction="in" />
            <lzc:method-param name="TestVendorExportDate" dbname="TestVendorExportDate" type="DateTime" required="True" direction="in" />
          </lzc:method-params>
        </lzc:method>
      </lzc:methods>
    </lzc:table>
    <lzc:table name="Picklist" alias="Picklist" filename="Picklist" namespace="ASTD.CIPortal" friendly-name="Picklist" logical-name="Picklist">
      <lzc:fields>
        <lzc:field name="Id" alias="id" autogenerate="True" type="Identity" friendly-name="Id" readonly="False" required="True" tableonly="False" logical-name="Id" dbname="Id" dbtype="Int">
          <lzc:indexes>
            <lzc:index name="PK_Picklist" type="Primary" constraintname="PK_Picklist_Id" cascade-delete="False" />
          </lzc:indexes>
        </lzc:field>
        <lzc:field name="Title" alias="title" autogenerate="False" type="Varchar" friendly-name="Title" readonly="False" required="True" size="50" tableonly="False" logical-name="Title" dbname="Title" dbtype="Varchar" />
      </lzc:fields>
      <lzc:methods>
        <lzc:method name="Create" object-name="Create" db-name="PicklistCreate" methodtype="Create" filename="PicklistCreate" return-result="False">
          <lzc:method-params>
            <lzc:method-param name="Id" dbname="Id" type="Int" required="True" direction="out" />
            <lzc:method-param name="Title" dbname="Title" type="Varchar" size="50" required="True" direction="in" />
          </lzc:method-params>
          <lzc:method-effects>
            <lzc:object-ref name="Picklist" effecttype="Create" ref="Picklist" alias="Picklist" pkfield="Id" fkfield="Id">
              <lzc:fields>
                <lzc:method-effect field="Id" type="Identity" dbtype="Int" dbname="Id" param="Id" autogenerate="True" />
                <lzc:method-effect field="Title" type="Varchar" dbtype="Varchar" dbname="Title" param="Title" autogenerate="False" />
              </lzc:fields>
            </lzc:object-ref>
          </lzc:method-effects>
        </lzc:method>
        <lzc:method name="Update" object-name="Update" db-name="PicklistUpdate" methodtype="Update" filename="PicklistUpdate" return-result="False">
          <lzc:method-params>
            <lzc:method-param name="Id" dbname="Id" type="Int" required="True" direction="in" />
            <lzc:method-param name="Title" dbname="Title" type="Varchar" size="50" required="True" direction="in" />
          </lzc:method-params>
          <lzc:method-effects>
            <lzc:object-ref name="Picklist" effecttype="Update" ref="Picklist" alias="Picklist" pkfield="Id" fkfield="Id">
              <lzc:method-filters>
                <lzc:method-filter field="Id" param="Id" />
              </lzc:method-filters>
              <lzc:fields>
                <lzc:method-effect field="Title" type="Varchar" dbtype="Varchar" dbname="Title" param="Title" autogenerate="False" />
              </lzc:fields>
            </lzc:object-ref>
          </lzc:method-effects>
        </lzc:method>
        <lzc:method name="Get" object-name="Get" db-name="PicklistGet" methodtype="Get" filename="PicklistGet" return-result="True">
          <lzc:method-params>
            <lzc:method-param name="Id" dbname="Id" type="Int" required="True" direction="in" />
          </lzc:method-params>
          <lzc:method-filters>
            <lzc:method-filter field="Id" param="Id" />
          </lzc:method-filters>
          <lzc:method-results>
            <lzc:object-ref name="Picklist" ref="Picklist" alias="Picklist" pkfield="Id" fkfield="Id" required="False">
              <lzc:fields>
                <lzc:method-result field="Id" alias="id" type="Int" dbname="Id" />
                <lzc:method-result field="Title" alias="title" type="Varchar" dbname="Title" size="50" />
              </lzc:fields>
            </lzc:object-ref>
          </lzc:method-results>
        </lzc:method>
        <lzc:method name="List" object-name="List" db-name="PicklistList" methodtype="List" filename="PicklistList" return-result="True">
          <lzc:method-results>
            <lzc:object-ref name="Picklist" ref="Picklist" alias="Picklist" fkfield="Id" required="True">
              <lzc:fields>
                <lzc:method-result field="Id" alias="Id" type="Int" dbname="Id" />
                <lzc:method-result field="Title" alias="Title" type="Varchar" dbname="Title" size="50" />
              </lzc:fields>
            </lzc:object-ref>
          </lzc:method-results>
        </lzc:method>
      </lzc:methods>
    </lzc:table>
    <lzc:table name="PicklistItem" alias="PicklistItem" filename="PicklistItem" namespace="ASTD.CIPortal" friendly-name="PicklistItem" logical-name="PicklistItem">
      <lzc:description>Defines an item in a picklist.</lzc:description>
      <lzc:fields>
        <lzc:field name="Id" alias="id" autogenerate="True" type="Identity" friendly-name="Id" readonly="False" required="True" tableonly="False" logical-name="Id" dbname="Id" dbtype="Int">
          <lzc:indexes>
            <lzc:index name="PK_PicklistItem" type="Primary" constraintname="PK_PicklistItem_Id" cascade-delete="False" />
          </lzc:indexes>
        </lzc:field>
        <lzc:field name="Picklist" alias="picklist" autogenerate="False" type="Int" friendly-name="Picklist" readonly="False" required="True" tableonly="False" logical-name="Picklist" dbname="PicklistId" dbtype="Int">
          <lzc:indexes>
            <lzc:index name="IDX_PicklistItem_Picklist" alias="picklist" accessor="Picklist" object="Picklist" type="Foreign" constraintname="FK_PicklistItem_Picklist" cascade-delete="False" />
          </lzc:indexes>
        </lzc:field>
        <lzc:field name="Code" alias="code" autogenerate="False" type="Varchar" friendly-name="Code" readonly="False" required="False" size="2" tableonly="False" logical-name="Code" dbname="Code" dbtype="Varchar" />
        <lzc:field name="Title" alias="title" autogenerate="False" type="Varchar" friendly-name="Title" readonly="False" required="True" size="255" tableonly="False" logical-name="Title" dbname="Title" dbtype="Varchar" />
        <lzc:field name="Active" alias="active" autogenerate="False" type="Bit" default="1" friendly-name="Active" readonly="False" required="True" tableonly="False" logical-name="Active" dbname="Active" dbtype="Bit" />
      </lzc:fields>
      <lzc:methods>
        <lzc:method name="Create" object-name="Create" db-name="PicklistItemCreate" methodtype="Create" filename="PicklistItemCreate" return-result="False">
          <lzc:method-params>
            <lzc:method-param name="Id" dbname="Id" type="Int" required="True" direction="out" />
            <lzc:method-param name="Picklist" dbname="PicklistId" type="Int" required="True" direction="in" />
            <lzc:method-param name="Code" dbname="Code" type="Varchar" size="2" required="False" direction="in" />
            <lzc:method-param name="Title" dbname="Title" type="Varchar" size="255" required="True" direction="in" />
            <lzc:method-param name="Active" dbname="Active" type="Bit" required="True" direction="in" />
          </lzc:method-params>
          <lzc:method-effects>
            <lzc:object-ref name="PicklistItem" effecttype="Create" ref="PicklistItem" alias="PicklistItem" pkfield="Id" fkfield="Id">
              <lzc:fields>
                <lzc:method-effect field="Id" type="Identity" dbtype="Int" dbname="Id" param="Id" autogenerate="True" />
                <lzc:method-effect field="Picklist" type="Int" dbtype="Int" dbname="PicklistId" param="Picklist" autogenerate="False" />
                <lzc:method-effect field="Code" type="Varchar" dbtype="Varchar" dbname="Code" param="Code" autogenerate="False" />
                <lzc:method-effect field="Title" type="Varchar" dbtype="Varchar" dbname="Title" param="Title" autogenerate="False" />
                <lzc:method-effect field="Active" type="Bit" dbtype="Bit" dbname="Active" param="Active" autogenerate="False" />
              </lzc:fields>
            </lzc:object-ref>
          </lzc:method-effects>
        </lzc:method>
        <lzc:method name="Update" object-name="Update" db-name="PicklistItemUpdate" methodtype="Update" filename="PicklistItemUpdate" return-result="False">
          <lzc:method-params>
            <lzc:method-param name="Id" dbname="Id" type="Int" required="True" direction="in" />
            <lzc:method-param name="Picklist" dbname="PicklistId" type="Int" required="True" direction="in" />
            <lzc:method-param name="Code" dbname="Code" type="Varchar" size="2" required="False" direction="in" />
            <lzc:method-param name="Title" dbname="Title" type="Varchar" size="255" required="True" direction="in" />
            <lzc:method-param name="Active" dbname="Active" type="Bit" required="True" direction="in" />
          </lzc:method-params>
          <lzc:method-effects>
            <lzc:object-ref name="PicklistItem" effecttype="Update" ref="PicklistItem" alias="PicklistItem" pkfield="Id" fkfield="Id">
              <lzc:method-filters>
                <lzc:method-filter field="Id" param="Id" />
              </lzc:method-filters>
              <lzc:fields>
                <lzc:method-effect field="Picklist" type="Int" dbtype="Int" dbname="PicklistId" param="Picklist" autogenerate="False" />
                <lzc:method-effect field="Code" type="Varchar" dbtype="Varchar" dbname="Code" param="Code" autogenerate="False" />
                <lzc:method-effect field="Title" type="Varchar" dbtype="Varchar" dbname="Title" param="Title" autogenerate="False" />
                <lzc:method-effect field="Active" type="Bit" dbtype="Bit" dbname="Active" param="Active" autogenerate="False" />
              </lzc:fields>
            </lzc:object-ref>
          </lzc:method-effects>
        </lzc:method>
        <lzc:method name="Get" object-name="Get" db-name="PicklistItemGet" methodtype="Get" filename="PicklistItemGet" return-result="True">
          <lzc:method-params>
            <lzc:method-param name="Id" dbname="Id" type="Int" required="True" direction="in" />
          </lzc:method-params>
          <lzc:method-filters>
            <lzc:method-filter field="Id" param="Id" />
          </lzc:method-filters>
          <lzc:method-results>
            <lzc:object-ref name="PicklistItem" ref="PicklistItem" alias="PicklistItem" pkfield="Id" fkfield="Id" required="False">
              <lzc:fields>
                <lzc:method-result field="Id" alias="id" type="Int" dbname="Id" />
                <lzc:method-result field="Picklist" alias="picklist" type="Int" dbname="PicklistId" />
                <lzc:method-result field="Code" alias="code" type="Varchar" dbname="Code" size="2" />
                <lzc:method-result field="Title" alias="title" type="Varchar" dbname="Title" size="255" />
                <lzc:method-result field="Active" alias="active" type="Bit" dbname="Active" />
              </lzc:fields>
            </lzc:object-ref>
          </lzc:method-results>
        </lzc:method>
        <lzc:method name="List" object-name="List" db-name="PicklistItemList" methodtype="List" filename="PicklistItemList" return-result="True">
          <lzc:method-results>
            <lzc:object-ref name="PicklistItem" ref="PicklistItem" alias="PicklistItem" fkfield="Id" required="True">
              <lzc:fields>
                <lzc:method-result field="Id" alias="Id" type="Int" dbname="Id" />
                <lzc:method-result field="Picklist" alias="PicklistId" type="Int" dbname="PicklistId" />
                <lzc:method-result field="Code" alias="Code" type="Varchar" dbname="Code" size="2" />
                <lzc:method-result field="Title" alias="Title" type="Varchar" dbname="Title" size="255" />
                <lzc:method-result field="Active" alias="Active" type="Bit" dbname="Active" />
              </lzc:fields>
            </lzc:object-ref>
          </lzc:method-results>
        </lzc:method>
        <lzc:method name="List" object-name="List" db-name="PicklistItemListByActive" methodtype="List" filename="PicklistItemListByActive" return-result="True">
          <lzc:method-params>
            <lzc:method-param name="Active" dbname="Active" type="Bit" required="True" direction="in" />
          </lzc:method-params>
          <lzc:method-filters>
            <lzc:method-filter field="Active" param="Active" />
          </lzc:method-filters>
          <lzc:method-results>
            <lzc:object-ref name="PicklistItem" ref="PicklistItem" alias="PicklistItem" fkfield="Id" required="True">
              <lzc:fields>
                <lzc:method-result field="Id" alias="Id" type="Int" dbname="Id" />
                <lzc:method-result field="Picklist" alias="PicklistId" type="Int" dbname="PicklistId" />
                <lzc:method-result field="Code" alias="Code" type="Varchar" dbname="Code" size="2" />
                <lzc:method-result field="Title" alias="Title" type="Varchar" dbname="Title" size="255" />
                <lzc:method-result field="Active" alias="Active" type="Bit" dbname="Active" />
              </lzc:fields>
            </lzc:object-ref>
          </lzc:method-results>
        </lzc:method>
        <lzc:method name="List" object-name="List" db-name="PicklistItemListByPicklist" methodtype="List" filename="PicklistItemListByPicklist" return-result="True">
          <lzc:method-params>
            <lzc:method-param name="Picklist" dbname="PicklistId" type="Int" required="True" direction="in" />
          </lzc:method-params>
          <lzc:method-filters>
            <lzc:method-filter field="Picklist" param="Picklist" />
          </lzc:method-filters>
          <lzc:method-results>
            <lzc:object-ref name="PicklistItem" ref="PicklistItem" alias="PicklistItem" fkfield="Id" required="True">
              <lzc:fields>
                <lzc:method-result field="Id" alias="Id" type="Int" dbname="Id" />
                <lzc:method-result field="Picklist" alias="PicklistId" type="Int" dbname="PicklistId" />
                <lzc:method-result field="Code" alias="Code" type="Varchar" dbname="Code" size="2" />
                <lzc:method-result field="Title" alias="Title" type="Varchar" dbname="Title" size="255" />
                <lzc:method-result field="Active" alias="Active" type="Bit" dbname="Active" />
              </lzc:fields>
            </lzc:object-ref>
          </lzc:method-results>
        </lzc:method>
        <lzc:method name="List" object-name="List" db-name="PicklistItemListByPicklistActive" methodtype="List" filename="PicklistItemListByPicklistActive" return-result="True">
          <lzc:method-params>
            <lzc:method-param name="Picklist" dbname="PicklistId" type="Int" required="True" direction="in" />
            <lzc:method-param name="Active" dbname="Active" type="Bit" required="True" direction="in" />
          </lzc:method-params>
          <lzc:method-filters>
            <lzc:method-filter field="Picklist" param="Picklist" />
            <lzc:method-filter field="Active" param="Active" />
          </lzc:method-filters>
          <lzc:method-results>
            <lzc:object-ref name="PicklistItem" ref="PicklistItem" alias="PicklistItem" fkfield="Id" required="True">
              <lzc:fields>
                <lzc:method-result field="Id" alias="Id" type="Int" dbname="Id" />
                <lzc:method-result field="Picklist" alias="PicklistId" type="Int" dbname="PicklistId" />
                <lzc:method-result field="Code" alias="Code" type="Varchar" dbname="Code" size="2" />
                <lzc:method-result field="Title" alias="Title" type="Varchar" dbname="Title" size="255" />
                <lzc:method-result field="Active" alias="Active" type="Bit" dbname="Active" />
              </lzc:fields>
            </lzc:object-ref>
          </lzc:method-results>
        </lzc:method>
      </lzc:methods>
    </lzc:table>
    <lzc:table name="TestWindow" alias="TestWindow" filename="TestWindow" namespace="ASTD.CIPortal" friendly-name="TestWindow" logical-name="TestWindow">
      <lzc:description>Defines the possible testing windows (start and end dates) for members.</lzc:description>
      <lzc:fields>
        <lzc:field name="Id" alias="id" autogenerate="True" type="Identity" friendly-name="Id" readonly="False" required="True" tableonly="False" logical-name="Id" dbname="Id" dbtype="Int">
          <lzc:indexes>
            <lzc:index name="PK_TestWindow" type="Primary" constraintname="PK_TestWindow_Id" cascade-delete="False" />
          </lzc:indexes>
        </lzc:field>
        <lzc:field name="Name" alias="name" autogenerate="False" type="Varchar" friendly-name="Name" readonly="False" required="True" size="50" tableonly="False" logical-name="Name" dbname="Name" dbtype="Varchar" />
        <lzc:field name="StartDate" alias="startdate" autogenerate="False" type="DateTime" friendly-name="StartDate" readonly="False" required="True" tableonly="False" logical-name="StartDate" dbname="StartDate" dbtype="DateTime" />
        <lzc:field name="EndDate" alias="enddate" autogenerate="False" type="DateTime" friendly-name="EndDate" readonly="False" required="True" tableonly="False" logical-name="EndDate" dbname="EndDate" dbtype="DateTime" />
        <lzc:field name="Active" alias="active" autogenerate="False" type="Bit" default="1" friendly-name="Active" readonly="False" required="True" tableonly="False" logical-name="Active" dbname="Active" dbtype="Bit" />
      </lzc:fields>
      <lzc:methods>
        <lzc:method name="Create" object-name="Create" db-name="TestWindowCreate" methodtype="Create" filename="TestWindowCreate" return-result="False">
          <lzc:method-params>
            <lzc:method-param name="Id" dbname="Id" type="Int" required="True" direction="out" />
            <lzc:method-param name="Name" dbname="Name" type="Varchar" size="50" required="True" direction="in" />
            <lzc:method-param name="StartDate" dbname="StartDate" type="DateTime" required="True" direction="in" />
            <lzc:method-param name="EndDate" dbname="EndDate" type="DateTime" required="True" direction="in" />
            <lzc:method-param name="Active" dbname="Active" type="Bit" required="True" direction="in" />
          </lzc:method-params>
          <lzc:method-effects>
            <lzc:object-ref name="TestWindow" effecttype="Create" ref="TestWindow" alias="TestWindow" pkfield="Id" fkfield="Id">
              <lzc:fields>
                <lzc:method-effect field="Id" type="Identity" dbtype="Int" dbname="Id" param="Id" autogenerate="True" />
                <lzc:method-effect field="Name" type="Varchar" dbtype="Varchar" dbname="Name" param="Name" autogenerate="False" />
                <lzc:method-effect field="StartDate" type="DateTime" dbtype="DateTime" dbname="StartDate" param="StartDate" autogenerate="False" />
                <lzc:method-effect field="EndDate" type="DateTime" dbtype="DateTime" dbname="EndDate" param="EndDate" autogenerate="False" />
                <lzc:method-effect field="Active" type="Bit" dbtype="Bit" dbname="Active" param="Active" autogenerate="False" />
              </lzc:fields>
            </lzc:object-ref>
          </lzc:method-effects>
        </lzc:method>
        <lzc:method name="Update" object-name="Update" db-name="TestWindowUpdate" methodtype="Update" filename="TestWindowUpdate" return-result="False">
          <lzc:method-params>
            <lzc:method-param name="Id" dbname="Id" type="Int" required="True" direction="in" />
            <lzc:method-param name="Name" dbname="Name" type="Varchar" size="50" required="True" direction="in" />
            <lzc:method-param name="StartDate" dbname="StartDate" type="DateTime" required="True" direction="in" />
            <lzc:method-param name="EndDate" dbname="EndDate" type="DateTime" required="True" direction="in" />
            <lzc:method-param name="Active" dbname="Active" type="Bit" required="True" direction="in" />
          </lzc:method-params>
          <lzc:method-effects>
            <lzc:object-ref name="TestWindow" effecttype="Update" ref="TestWindow" alias="TestWindow" pkfield="Id" fkfield="Id">
              <lzc:method-filters>
                <lzc:method-filter field="Id" param="Id" />
              </lzc:method-filters>
              <lzc:fields>
                <lzc:method-effect field="Name" type="Varchar" dbtype="Varchar" dbname="Name" param="Name" autogenerate="False" />
                <lzc:method-effect field="StartDate" type="DateTime" dbtype="DateTime" dbname="StartDate" param="StartDate" autogenerate="False" />
                <lzc:method-effect field="EndDate" type="DateTime" dbtype="DateTime" dbname="EndDate" param="EndDate" autogenerate="False" />
                <lzc:method-effect field="Active" type="Bit" dbtype="Bit" dbname="Active" param="Active" autogenerate="False" />
              </lzc:fields>
            </lzc:object-ref>
          </lzc:method-effects>
        </lzc:method>
        <lzc:method name="Get" object-name="Get" db-name="TestWindowGet" methodtype="Get" filename="TestWindowGet" return-result="True">
          <lzc:method-params>
            <lzc:method-param name="Id" dbname="Id" type="Int" required="True" direction="in" />
          </lzc:method-params>
          <lzc:method-filters>
            <lzc:method-filter field="Id" param="Id" />
          </lzc:method-filters>
          <lzc:method-results>
            <lzc:object-ref name="TestWindow" ref="TestWindow" alias="TestWindow" pkfield="Id" fkfield="Id" required="False">
              <lzc:fields>
                <lzc:method-result field="Id" alias="id" type="Int" dbname="Id" />
                <lzc:method-result field="Name" alias="name" type="Varchar" dbname="Name" size="50" />
                <lzc:method-result field="StartDate" alias="startdate" type="DateTime" dbname="StartDate" />
                <lzc:method-result field="EndDate" alias="enddate" type="DateTime" dbname="EndDate" />
                <lzc:method-result field="Active" alias="active" type="Bit" dbname="Active" />
              </lzc:fields>
            </lzc:object-ref>
          </lzc:method-results>
        </lzc:method>
        <lzc:method name="List" object-name="List" db-name="TestWindowList" methodtype="List" filename="TestWindowList" return-result="True">
          <lzc:method-results>
            <lzc:object-ref name="TestWindow" ref="TestWindow" alias="TestWindow" fkfield="Id" required="True">
              <lzc:fields>
                <lzc:method-result field="Id" alias="Id" type="Int" dbname="Id" />
                <lzc:method-result field="Name" alias="Name" type="Varchar" dbname="Name" size="50" />
                <lzc:method-result field="StartDate" alias="StartDate" type="DateTime" dbname="StartDate" />
                <lzc:method-result field="EndDate" alias="EndDate" type="DateTime" dbname="EndDate" />
                <lzc:method-result field="Active" alias="Active" type="Bit" dbname="Active" />
              </lzc:fields>
            </lzc:object-ref>
          </lzc:method-results>
        </lzc:method>
        <lzc:method name="List" object-name="List" db-name="TestWindowListByActive" methodtype="List" filename="TestWindowListByActive" return-result="True">
          <lzc:method-params>
            <lzc:method-param name="Active" dbname="Active" type="Bit" required="True" direction="in" />
          </lzc:method-params>
          <lzc:method-filters>
            <lzc:method-filter field="Active" param="Active" />
          </lzc:method-filters>
          <lzc:method-results>
            <lzc:object-ref name="TestWindow" ref="TestWindow" alias="TestWindow" fkfield="Id" required="True">
              <lzc:fields>
                <lzc:method-result field="Id" alias="Id" type="Int" dbname="Id" />
                <lzc:method-result field="Name" alias="Name" type="Varchar" dbname="Name" size="50" />
                <lzc:method-result field="StartDate" alias="StartDate" type="DateTime" dbname="StartDate" />
                <lzc:method-result field="EndDate" alias="EndDate" type="DateTime" dbname="EndDate" />
                <lzc:method-result field="Active" alias="Active" type="Bit" dbname="Active" />
              </lzc:fields>
            </lzc:object-ref>
          </lzc:method-results>
        </lzc:method>
      </lzc:methods>
    </lzc:table>
    <lzc:table name="TestStatus" alias="TestStatus" filename="TestStatus" namespace="ASTD.CIPortal" friendly-name="TestStatus" logical-name="TestStatus">
      <lzc:description>Defines the possible status codes for a member's testing completion.</lzc:description>
      <lzc:fields>
        <lzc:field name="Id" alias="id" autogenerate="True" type="Identity" friendly-name="Id" readonly="False" required="True" tableonly="False" logical-name="Id" dbname="Id" dbtype="Int">
          <lzc:indexes>
            <lzc:index name="PK_TestStatus" type="Primary" constraintname="PK_TestStatus_Id" cascade-delete="False" />
          </lzc:indexes>
        </lzc:field>
        <lzc:field name="Title" alias="title" autogenerate="False" type="Varchar" friendly-name="Title" readonly="False" required="True" size="50" tableonly="False" logical-name="Title" dbname="Title" dbtype="Varchar" />
      </lzc:fields>
      <lzc:methods>
        <lzc:method name="Create" object-name="Create" db-name="TestStatusCreate" methodtype="Create" filename="TestStatusCreate" return-result="False">
          <lzc:method-params>
            <lzc:method-param name="Id" dbname="Id" type="Int" required="True" direction="out" />
            <lzc:method-param name="Title" dbname="Title" type="Varchar" size="50" required="True" direction="in" />
          </lzc:method-params>
          <lzc:method-effects>
            <lzc:object-ref name="TestStatus" effecttype="Create" ref="TestStatus" alias="TestStatus" pkfield="Id" fkfield="Id">
              <lzc:fields>
                <lzc:method-effect field="Id" type="Identity" dbtype="Int" dbname="Id" param="Id" autogenerate="True" />
                <lzc:method-effect field="Title" type="Varchar" dbtype="Varchar" dbname="Title" param="Title" autogenerate="False" />
              </lzc:fields>
            </lzc:object-ref>
          </lzc:method-effects>
        </lzc:method>
        <lzc:method name="Update" object-name="Update" db-name="TestStatusUpdate" methodtype="Update" filename="TestStatusUpdate" return-result="False">
          <lzc:method-params>
            <lzc:method-param name="Id" dbname="Id" type="Int" required="True" direction="in" />
            <lzc:method-param name="Title" dbname="Title" type="Varchar" size="50" required="True" direction="in" />
          </lzc:method-params>
          <lzc:method-effects>
            <lzc:object-ref name="TestStatus" effecttype="Update" ref="TestStatus" alias="TestStatus" pkfield="Id" fkfield="Id">
              <lzc:method-filters>
                <lzc:method-filter field="Id" param="Id" />
              </lzc:method-filters>
              <lzc:fields>
                <lzc:method-effect field="Title" type="Varchar" dbtype="Varchar" dbname="Title" param="Title" autogenerate="False" />
              </lzc:fields>
            </lzc:object-ref>
          </lzc:method-effects>
        </lzc:method>
        <lzc:method name="Get" object-name="Get" db-name="TestStatusGet" methodtype="Get" filename="TestStatusGet" return-result="True">
          <lzc:method-params>
            <lzc:method-param name="Id" dbname="Id" type="Int" required="True" direction="in" />
          </lzc:method-params>
          <lzc:method-filters>
            <lzc:method-filter field="Id" param="Id" />
          </lzc:method-filters>
          <lzc:method-results>
            <lzc:object-ref name="TestStatus" ref="TestStatus" alias="TestStatus" pkfield="Id" fkfield="Id" required="False">
              <lzc:fields>
                <lzc:method-result field="Id" alias="id" type="Int" dbname="Id" />
                <lzc:method-result field="Title" alias="title" type="Varchar" dbname="Title" size="50" />
              </lzc:fields>
            </lzc:object-ref>
          </lzc:method-results>
        </lzc:method>
        <lzc:method name="List" object-name="List" db-name="TestStatusList" methodtype="List" filename="TestStatusList" return-result="True">
          <lzc:method-results>
            <lzc:object-ref name="TestStatus" ref="TestStatus" alias="TestStatus" fkfield="Id" required="True">
              <lzc:fields>
                <lzc:method-result field="Id" alias="Id" type="Int" dbname="Id" />
                <lzc:method-result field="Title" alias="Title" type="Varchar" dbname="Title" size="50" />
              </lzc:fields>
            </lzc:object-ref>
          </lzc:method-results>
        </lzc:method>
      </lzc:methods>
    </lzc:table>
    <lzc:table name="CustomerExpertise" alias="CustomerExpertise" filename="CustomerExpertise" namespace="ASTD.CIPortal" friendly-name="CustomerExpertise" logical-name="CustomerExpertise">
      <lzc:fields>
        <lzc:field name="Id" alias="id" autogenerate="True" type="Identity" friendly-name="Id" readonly="False" required="True" tableonly="False" logical-name="Id" dbname="Id" dbtype="Int">
          <lzc:indexes>
            <lzc:index name="PK_CustomerExpertise" type="Primary" constraintname="PK_CustomerExpertise_Id" cascade-delete="False" />
          </lzc:indexes>
        </lzc:field>
        <lzc:field name="Customer" alias="customer" autogenerate="False" type="Int" friendly-name="Customer" readonly="False" required="False" tableonly="False" logical-name="Customer" dbname="CustomerId" dbtype="Int">
          <lzc:indexes>
            <lzc:index name="IDX_CustomerExpertise_Customer" alias="customer" accessor="Customer" object="Customer" type="Foreign" constraintname="FK_CustomerExpertise_Customer" cascade-delete="False" />
          </lzc:indexes>
        </lzc:field>
        <lzc:field name="AreaOfExpertise" alias="areaofexpertise" autogenerate="False" type="Int" friendly-name="AreaOfExpertise" readonly="False" required="False" tableonly="False" logical-name="AreaOfExpertise" dbname="AreaOfExpertiseId" dbtype="Int">
          <lzc:indexes>
            <lzc:index name="IDX_CustomerExpertise_AreaOfExpertise" alias="areaofexpertise" accessor="AreaOfExpertise" object="PicklistItem" type="Foreign" constraintname="FK_CustomerExpertise_AreaOfExpertise" cascade-delete="False" />
          </lzc:indexes>
        </lzc:field>
      </lzc:fields>
      <lzc:methods>
        <lzc:method name="Create" object-name="Create" db-name="CustomerExpertiseCreate" methodtype="Create" filename="CustomerExpertiseCreate" return-result="False">
          <lzc:method-params>
            <lzc:method-param name="Id" dbname="Id" type="Int" required="True" direction="out" />
            <lzc:method-param name="Customer" dbname="CustomerId" type="Int" required="False" direction="in" />
            <lzc:method-param name="AreaOfExpertise" dbname="AreaOfExpertiseId" type="Int" required="False" direction="in" />
          </lzc:method-params>
          <lzc:method-effects>
            <lzc:object-ref name="CustomerExpertise" effecttype="Create" ref="CustomerExpertise" alias="CustomerExpertise" pkfield="Id" fkfield="Id">
              <lzc:fields>
                <lzc:method-effect field="Id" type="Identity" dbtype="Int" dbname="Id" param="Id" autogenerate="True" />
                <lzc:method-effect field="Customer" type="Int" dbtype="Int" dbname="CustomerId" param="Customer" autogenerate="False" />
                <lzc:method-effect field="AreaOfExpertise" type="Int" dbtype="Int" dbname="AreaOfExpertiseId" param="AreaOfExpertise" autogenerate="False" />
              </lzc:fields>
            </lzc:object-ref>
          </lzc:method-effects>
        </lzc:method>
      </lzc:methods>
    </lzc:table>
    <lzc:table name="CustomerAccomodation" alias="CustomerAccomodation" filename="CustomerAccomodation" namespace="ASTD.CIPortal" friendly-name="CustomerAccomodation" logical-name="CustomerAccomodation">
      <lzc:fields>
        <lzc:field name="Id" alias="id" autogenerate="True" type="Identity" friendly-name="Id" readonly="False" required="True" tableonly="False" logical-name="Id" dbname="Id" dbtype="Int">
          <lzc:indexes>
            <lzc:index name="PK_CustomerAccomodation" type="Primary" constraintname="PK_CustomerAccomodation_Id" cascade-delete="False" />
          </lzc:indexes>
        </lzc:field>
        <lzc:field name="Customer" alias="customer" autogenerate="False" type="Int" friendly-name="Customer" readonly="False" required="False" tableonly="False" logical-name="Customer" dbname="CustomerId" dbtype="Int">
          <lzc:indexes>
            <lzc:index name="IDX_CustomerAccomodation_Customer" alias="customer" accessor="Customer" object="Customer" type="Foreign" constraintname="FK_CustomerAccomodation_Customer" cascade-delete="False" />
          </lzc:indexes>
        </lzc:field>
        <lzc:field name="ADACode" alias="adacode" autogenerate="False" type="Int" friendly-name="ADACode" readonly="False" required="False" tableonly="False" logical-name="ADACode" dbname="ADACodeId" dbtype="Int">
          <lzc:indexes>
            <lzc:index name="IDX_CustomerAccomodation_ADACode" alias="adacode" accessor="ADACode" object="PicklistItem" type="Foreign" constraintname="FK_CustomerAccomodation_ADACode" cascade-delete="False" />
          </lzc:indexes>
        </lzc:field>
      </lzc:fields>
      <lzc:methods>
        <lzc:method name="Create" object-name="Create" db-name="CustomerAccomodationCreate" methodtype="Create" filename="CustomerAccomodationCreate" return-result="False">
          <lzc:method-params>
            <lzc:method-param name="Id" dbname="Id" type="Int" required="True" direction="out" />
            <lzc:method-param name="Customer" dbname="CustomerId" type="Int" required="False" direction="in" />
            <lzc:method-param name="ADACode" dbname="ADACodeId" type="Int" required="False" direction="in" />
          </lzc:method-params>
          <lzc:method-effects>
            <lzc:object-ref name="CustomerAccomodation" effecttype="Create" ref="CustomerAccomodation" alias="CustomerAccomodation" pkfield="Id" fkfield="Id">
              <lzc:fields>
                <lzc:method-effect field="Id" type="Identity" dbtype="Int" dbname="Id" param="Id" autogenerate="True" />
                <lzc:method-effect field="Customer" type="Int" dbtype="Int" dbname="CustomerId" param="Customer" autogenerate="False" />
                <lzc:method-effect field="ADACode" type="Int" dbtype="Int" dbname="ADACodeId" param="ADACode" autogenerate="False" />
              </lzc:fields>
            </lzc:object-ref>
          </lzc:method-effects>
        </lzc:method>
      </lzc:methods>
    </lzc:table>
    <lzc:table name="Employer" alias="Employer" filename="Employer" namespace="ASTD.CIPortal" friendly-name="Employer" logical-name="Employer">
      <lzc:fields>
        <lzc:field name="Id" alias="id" autogenerate="True" type="Identity" friendly-name="Id" readonly="False" required="True" tableonly="False" logical-name="Id" dbname="Id" dbtype="Int">
          <lzc:indexes>
            <lzc:index name="PK_Employer" type="Primary" constraintname="PK_Employer_Id" cascade-delete="False" />
          </lzc:indexes>
        </lzc:field>
        <lzc:field name="Customer" alias="customer" autogenerate="False" type="Int" friendly-name="Customer" readonly="False" required="False" tableonly="False" logical-name="Customer" dbname="CustomerId" dbtype="Int">
          <lzc:indexes>
            <lzc:index name="IDX_Employer_Customer" alias="customer" accessor="Customer" object="Customer" type="Foreign" constraintname="FK_Employer_Customer" cascade-delete="False" />
          </lzc:indexes>
        </lzc:field>
        <lzc:field name="Name" alias="name" autogenerate="False" type="Varchar" friendly-name="Name" readonly="False" required="True" size="50" tableonly="False" logical-name="Name" dbname="Name" dbtype="Varchar" />
        <lzc:field name="EmployedFrom" alias="employedfrom" autogenerate="False" type="DateTime" friendly-name="EmployedFrom" readonly="False" required="False" tableonly="False" logical-name="EmployedFrom" dbname="EmployedFrom" dbtype="DateTime" />
        <lzc:field name="EmployedTo" alias="employedto" autogenerate="False" type="DateTime" friendly-name="EmployedTo" readonly="False" required="False" tableonly="False" logical-name="EmployedTo" dbname="EmployedTo" dbtype="DateTime" />
        <lzc:field name="Title" alias="title" autogenerate="False" type="Varchar" friendly-name="Title" readonly="False" required="True" size="50" tableonly="False" logical-name="Title" dbname="Title" dbtype="Varchar" />
        <lzc:field name="Address" alias="address" autogenerate="False" type="Varchar" friendly-name="Address" readonly="False" required="False" size="50" tableonly="False" logical-name="Address" dbname="Address" dbtype="Varchar" />
        <lzc:field name="City" alias="city" autogenerate="False" type="Varchar" friendly-name="City" readonly="False" required="False" size="50" tableonly="False" logical-name="City" dbname="City" dbtype="Varchar" />
        <lzc:field name="State" alias="state" autogenerate="False" type="Int" friendly-name="State" readonly="False" required="False" tableonly="False" logical-name="State" dbname="StateId" dbtype="Int">
          <lzc:indexes>
            <lzc:index name="IDX_Employer_State" alias="state" accessor="State" object="PicklistItem" type="Foreign" constraintname="FK_Employer_State" cascade-delete="False" />
          </lzc:indexes>
        </lzc:field>
        <lzc:field name="Country" alias="country" autogenerate="False" type="Int" friendly-name="Country" readonly="False" required="False" tableonly="False" logical-name="Country" dbname="CountryId" dbtype="Int">
          <lzc:indexes>
            <lzc:index name="IDX_Employer_Country" alias="country" accessor="Country" object="PicklistItem" type="Foreign" constraintname="FK_Employer_Country" cascade-delete="False" />
          </lzc:indexes>
        </lzc:field>
        <lzc:field name="ZipCode" alias="zipcode" autogenerate="False" type="Varchar" friendly-name="ZipCode" readonly="False" required="False" size="10" tableonly="False" logical-name="ZipCode" dbname="ZipCode" dbtype="Varchar" />
      </lzc:fields>
      <lzc:methods>
        <lzc:method name="Create" object-name="Create" db-name="EmployerCreate" methodtype="Create" filename="EmployerCreate" return-result="False">
          <lzc:method-params>
            <lzc:method-param name="Id" dbname="Id" type="Int" required="True" direction="out" />
            <lzc:method-param name="Customer" dbname="CustomerId" type="Int" required="False" direction="in" />
            <lzc:method-param name="Name" dbname="Name" type="Varchar" size="50" required="True" direction="in" />
            <lzc:method-param name="EmployedFrom" dbname="EmployedFrom" type="DateTime" required="False" direction="in" />
            <lzc:method-param name="EmployedTo" dbname="EmployedTo" type="DateTime" required="False" direction="in" />
            <lzc:method-param name="Title" dbname="Title" type="Varchar" size="50" required="True" direction="in" />
            <lzc:method-param name="Address" dbname="Address" type="Varchar" size="50" required="False" direction="in" />
            <lzc:method-param name="City" dbname="City" type="Varchar" size="50" required="False" direction="in" />
            <lzc:method-param name="State" dbname="StateId" type="Int" required="False" direction="in" />
            <lzc:method-param name="Country" dbname="CountryId" type="Int" required="False" direction="in" />
            <lzc:method-param name="ZipCode" dbname="ZipCode" type="Varchar" size="10" required="False" direction="in" />
          </lzc:method-params>
          <lzc:method-effects>
            <lzc:object-ref name="Employer" effecttype="Create" ref="Employer" alias="Employer" pkfield="Id" fkfield="Id">
              <lzc:fields>
                <lzc:method-effect field="Id" type="Identity" dbtype="Int" dbname="Id" param="Id" autogenerate="True" />
                <lzc:method-effect field="Customer" type="Int" dbtype="Int" dbname="CustomerId" param="Customer" autogenerate="False" />
                <lzc:method-effect field="Name" type="Varchar" dbtype="Varchar" dbname="Name" param="Name" autogenerate="False" />
                <lzc:method-effect field="EmployedFrom" type="DateTime" dbtype="DateTime" dbname="EmployedFrom" param="EmployedFrom" autogenerate="False" />
                <lzc:method-effect field="EmployedTo" type="DateTime" dbtype="DateTime" dbname="EmployedTo" param="EmployedTo" autogenerate="False" />
                <lzc:method-effect field="Title" type="Varchar" dbtype="Varchar" dbname="Title" param="Title" autogenerate="False" />
                <lzc:method-effect field="Address" type="Varchar" dbtype="Varchar" dbname="Address" param="Address" autogenerate="False" />
                <lzc:method-effect field="City" type="Varchar" dbtype="Varchar" dbname="City" param="City" autogenerate="False" />
                <lzc:method-effect field="State" type="Int" dbtype="Int" dbname="StateId" param="State" autogenerate="False" />
                <lzc:method-effect field="Country" type="Int" dbtype="Int" dbname="CountryId" param="Country" autogenerate="False" />
                <lzc:method-effect field="ZipCode" type="Varchar" dbtype="Varchar" dbname="ZipCode" param="ZipCode" autogenerate="False" />
              </lzc:fields>
            </lzc:object-ref>
          </lzc:method-effects>
        </lzc:method>
        <lzc:method name="Update" object-name="Update" db-name="EmployerUpdate" methodtype="Update" filename="EmployerUpdate" return-result="False">
          <lzc:method-params>
            <lzc:method-param name="Id" dbname="Id" type="Int" required="True" direction="in" />
            <lzc:method-param name="Customer" dbname="CustomerId" type="Int" required="False" direction="in" />
            <lzc:method-param name="Name" dbname="Name" type="Varchar" size="50" required="True" direction="in" />
            <lzc:method-param name="EmployedFrom" dbname="EmployedFrom" type="DateTime" required="False" direction="in" />
            <lzc:method-param name="EmployedTo" dbname="EmployedTo" type="DateTime" required="False" direction="in" />
            <lzc:method-param name="Title" dbname="Title" type="Varchar" size="50" required="True" direction="in" />
            <lzc:method-param name="Address" dbname="Address" type="Varchar" size="50" required="False" direction="in" />
            <lzc:method-param name="City" dbname="City" type="Varchar" size="50" required="False" direction="in" />
            <lzc:method-param name="State" dbname="StateId" type="Int" required="False" direction="in" />
            <lzc:method-param name="Country" dbname="CountryId" type="Int" required="False" direction="in" />
            <lzc:method-param name="ZipCode" dbname="ZipCode" type="Varchar" size="10" required="False" direction="in" />
          </lzc:method-params>
          <lzc:method-effects>
            <lzc:object-ref name="Employer" effecttype="Update" ref="Employer" alias="Employer" pkfield="Id" fkfield="Id">
              <lzc:method-filters>
                <lzc:method-filter field="Id" param="Id" />
              </lzc:method-filters>
              <lzc:fields>
                <lzc:method-effect field="Customer" type="Int" dbtype="Int" dbname="CustomerId" param="Customer" autogenerate="False" />
                <lzc:method-effect field="Name" type="Varchar" dbtype="Varchar" dbname="Name" param="Name" autogenerate="False" />
                <lzc:method-effect field="EmployedFrom" type="DateTime" dbtype="DateTime" dbname="EmployedFrom" param="EmployedFrom" autogenerate="False" />
                <lzc:method-effect field="EmployedTo" type="DateTime" dbtype="DateTime" dbname="EmployedTo" param="EmployedTo" autogenerate="False" />
                <lzc:method-effect field="Title" type="Varchar" dbtype="Varchar" dbname="Title" param="Title" autogenerate="False" />
                <lzc:method-effect field="Address" type="Varchar" dbtype="Varchar" dbname="Address" param="Address" autogenerate="False" />
                <lzc:method-effect field="City" type="Varchar" dbtype="Varchar" dbname="City" param="City" autogenerate="False" />
                <lzc:method-effect field="State" type="Int" dbtype="Int" dbname="StateId" param="State" autogenerate="False" />
                <lzc:method-effect field="Country" type="Int" dbtype="Int" dbname="CountryId" param="Country" autogenerate="False" />
                <lzc:method-effect field="ZipCode" type="Varchar" dbtype="Varchar" dbname="ZipCode" param="ZipCode" autogenerate="False" />
              </lzc:fields>
            </lzc:object-ref>
          </lzc:method-effects>
        </lzc:method>
        <lzc:method name="Get" object-name="Get" db-name="EmployerGet" methodtype="Get" filename="EmployerGet" return-result="True">
          <lzc:method-params>
            <lzc:method-param name="Id" dbname="Id" type="Int" required="True" direction="in" />
          </lzc:method-params>
          <lzc:method-filters>
            <lzc:method-filter field="Id" param="Id" />
          </lzc:method-filters>
          <lzc:method-results>
            <lzc:object-ref name="Employer" ref="Employer" alias="Employer" pkfield="Id" fkfield="Id" required="False">
              <lzc:fields>
                <lzc:method-result field="Id" alias="id" type="Int" dbname="Id" />
                <lzc:method-result field="Customer" alias="customer" type="Int" dbname="CustomerId" />
                <lzc:method-result field="Name" alias="name" type="Varchar" dbname="Name" size="50" />
                <lzc:method-result field="EmployedFrom" alias="employedfrom" type="DateTime" dbname="EmployedFrom" />
                <lzc:method-result field="EmployedTo" alias="employedto" type="DateTime" dbname="EmployedTo" />
                <lzc:method-result field="Title" alias="title" type="Varchar" dbname="Title" size="50" />
                <lzc:method-result field="Address" alias="address" type="Varchar" dbname="Address" size="50" />
                <lzc:method-result field="City" alias="city" type="Varchar" dbname="City" size="50" />
                <lzc:method-result field="State" alias="state" type="Int" dbname="StateId" />
                <lzc:method-result field="Country" alias="country" type="Int" dbname="CountryId" />
                <lzc:method-result field="ZipCode" alias="zipcode" type="Varchar" dbname="ZipCode" size="10" />
              </lzc:fields>
            </lzc:object-ref>
          </lzc:method-results>
        </lzc:method>
        <lzc:method name="List" object-name="List" db-name="EmployerListByCustomer" methodtype="List" filename="EmployerListByCustomer" return-result="True">
          <lzc:method-params>
            <lzc:method-param name="Customer" dbname="CustomerId" type="Int" required="True" direction="in" />
          </lzc:method-params>
          <lzc:method-filters>
            <lzc:method-filter field="Customer" param="Customer" />
          </lzc:method-filters>
          <lzc:method-results>
            <lzc:object-ref name="Employer" ref="Employer" alias="Employer" fkfield="Id" required="True">
              <lzc:fields>
                <lzc:method-result field="Id" alias="Id" type="Int" dbname="Id" />
                <lzc:method-result field="Customer" alias="CustomerId" type="Int" dbname="CustomerId" />
                <lzc:method-result field="Name" alias="Name" type="Varchar" dbname="Name" size="50" />
                <lzc:method-result field="EmployedFrom" alias="EmployedFrom" type="DateTime" dbname="EmployedFrom" />
                <lzc:method-result field="EmployedTo" alias="EmployedTo" type="DateTime" dbname="EmployedTo" />
                <lzc:method-result field="Title" alias="Title" type="Varchar" dbname="Title" size="50" />
                <lzc:method-result field="Address" alias="Address" type="Varchar" dbname="Address" size="50" />
                <lzc:method-result field="City" alias="City" type="Varchar" dbname="City" size="50" />
                <lzc:method-result field="State" alias="StateId" type="Int" dbname="StateId" />
                <lzc:method-result field="Country" alias="CountryId" type="Int" dbname="CountryId" />
                <lzc:method-result field="ZipCode" alias="ZipCode" type="Varchar" dbname="ZipCode" size="10" />
              </lzc:fields>
            </lzc:object-ref>
            <lzc:object-ref name="State" ref="PicklistItem" alias="state" pkfield="Id" fkfield="StateId" required="False">
              <lzc:fields>
                <lzc:method-result name="Title" field="Title" alias="StateTitle" type="Varchar" dbname="Title" size="255" />
              </lzc:fields>
            </lzc:object-ref>
            <lzc:object-ref name="Country" ref="PicklistItem" alias="country" pkfield="Id" fkfield="CountryId" required="False">
              <lzc:fields>
                <lzc:method-result name="Title" field="Title" alias="CountryTitle" type="Varchar" dbname="Title" size="255" />
              </lzc:fields>
            </lzc:object-ref>
          </lzc:method-results>
        </lzc:method>
      </lzc:methods>
    </lzc:table>
    <lzc:table name="Institution" alias="Institution" filename="Institution" namespace="ASTD.CIPortal" friendly-name="Institution" logical-name="Institution">
      <lzc:fields>
        <lzc:field name="Id" alias="id" autogenerate="True" type="Identity" friendly-name="Id" readonly="False" required="True" tableonly="False" logical-name="Id" dbname="Id" dbtype="Int">
          <lzc:indexes>
            <lzc:index name="PK_Institution" type="Primary" constraintname="PK_Institution_Id" cascade-delete="False" />
          </lzc:indexes>
        </lzc:field>
        <lzc:field name="Customer" alias="customer" autogenerate="False" type="Int" friendly-name="Customer" readonly="False" required="False" tableonly="False" logical-name="Customer" dbname="CustomerId" dbtype="Int">
          <lzc:indexes>
            <lzc:index name="IDX_Institution_Customer" alias="customer" accessor="Customer" object="Customer" type="Foreign" constraintname="FK_Institution_Customer" cascade-delete="False" />
          </lzc:indexes>
        </lzc:field>
        <lzc:field name="From" alias="from" autogenerate="False" type="DateTime" friendly-name="From" readonly="False" required="False" tableonly="False" logical-name="From" dbname="From" dbtype="DateTime" />
        <lzc:field name="To" alias="to" autogenerate="False" type="DateTime" friendly-name="To" readonly="False" required="False" tableonly="False" logical-name="To" dbname="To" dbtype="DateTime" />
        <lzc:field name="Name" alias="name" autogenerate="False" type="Varchar" friendly-name="Name" readonly="False" required="True" size="50" tableonly="False" logical-name="Name" dbname="Name" dbtype="Varchar" />
        <lzc:field name="Address" alias="address" autogenerate="False" type="Varchar" friendly-name="Address" readonly="False" required="False" size="50" tableonly="False" logical-name="Address" dbname="Address" dbtype="Varchar" />
        <lzc:field name="City" alias="city" autogenerate="False" type="Varchar" friendly-name="City" readonly="False" required="False" size="50" tableonly="False" logical-name="City" dbname="City" dbtype="Varchar" />
        <lzc:field name="State" alias="state" autogenerate="False" type="Int" friendly-name="State" readonly="False" required="False" tableonly="False" logical-name="State" dbname="StateId" dbtype="Int">
          <lzc:indexes>
            <lzc:index name="IDX_Institution_State" alias="state" accessor="State" object="PicklistItem" type="Foreign" constraintname="FK_Institution_State" cascade-delete="False" />
          </lzc:indexes>
        </lzc:field>
        <lzc:field name="Country" alias="country" autogenerate="False" type="Int" friendly-name="Country" readonly="False" required="False" tableonly="False" logical-name="Country" dbname="CountryId" dbtype="Int">
          <lzc:indexes>
            <lzc:index name="IDX_Institution_Country" alias="country" accessor="Country" object="PicklistItem" type="Foreign" constraintname="FK_Institution_Country" cascade-delete="False" />
          </lzc:indexes>
        </lzc:field>
        <lzc:field name="ZipCode" alias="zipcode" autogenerate="False" type="Varchar" friendly-name="ZipCode" readonly="False" required="False" size="10" tableonly="False" logical-name="ZipCode" dbname="ZipCode" dbtype="Varchar" />
        <lzc:field name="Email" alias="email" autogenerate="False" type="Varchar" friendly-name="Email" readonly="False" required="False" size="255" tableonly="False" logical-name="Email" dbname="Email" dbtype="Varchar" />
      </lzc:fields>
      <lzc:methods>
        <lzc:method name="Create" object-name="Create" db-name="InstitutionCreate" methodtype="Create" filename="InstitutionCreate" return-result="False">
          <lzc:method-params>
            <lzc:method-param name="Id" dbname="Id" type="Int" required="True" direction="out" />
            <lzc:method-param name="Customer" dbname="CustomerId" type="Int" required="False" direction="in" />
            <lzc:method-param name="From" dbname="From" type="DateTime" required="False" direction="in" />
            <lzc:method-param name="To" dbname="To" type="DateTime" required="False" direction="in" />
            <lzc:method-param name="Name" dbname="Name" type="Varchar" size="50" required="True" direction="in" />
            <lzc:method-param name="Address" dbname="Address" type="Varchar" size="50" required="False" direction="in" />
            <lzc:method-param name="City" dbname="City" type="Varchar" size="50" required="False" direction="in" />
            <lzc:method-param name="State" dbname="StateId" type="Int" required="False" direction="in" />
            <lzc:method-param name="Country" dbname="CountryId" type="Int" required="False" direction="in" />
            <lzc:method-param name="ZipCode" dbname="ZipCode" type="Varchar" size="10" required="False" direction="in" />
            <lzc:method-param name="Email" dbname="Email" type="Varchar" size="255" required="False" direction="in" />
          </lzc:method-params>
          <lzc:method-effects>
            <lzc:object-ref name="Institution" effecttype="Create" ref="Institution" alias="Institution" pkfield="Id" fkfield="Id">
              <lzc:fields>
                <lzc:method-effect field="Id" type="Identity" dbtype="Int" dbname="Id" param="Id" autogenerate="True" />
                <lzc:method-effect field="Customer" type="Int" dbtype="Int" dbname="CustomerId" param="Customer" autogenerate="False" />
                <lzc:method-effect field="From" type="DateTime" dbtype="DateTime" dbname="From" param="From" autogenerate="False" />
                <lzc:method-effect field="To" type="DateTime" dbtype="DateTime" dbname="To" param="To" autogenerate="False" />
                <lzc:method-effect field="Name" type="Varchar" dbtype="Varchar" dbname="Name" param="Name" autogenerate="False" />
                <lzc:method-effect field="Address" type="Varchar" dbtype="Varchar" dbname="Address" param="Address" autogenerate="False" />
                <lzc:method-effect field="City" type="Varchar" dbtype="Varchar" dbname="City" param="City" autogenerate="False" />
                <lzc:method-effect field="State" type="Int" dbtype="Int" dbname="StateId" param="State" autogenerate="False" />
                <lzc:method-effect field="Country" type="Int" dbtype="Int" dbname="CountryId" param="Country" autogenerate="False" />
                <lzc:method-effect field="ZipCode" type="Varchar" dbtype="Varchar" dbname="ZipCode" param="ZipCode" autogenerate="False" />
                <lzc:method-effect field="Email" type="Varchar" dbtype="Varchar" dbname="Email" param="Email" autogenerate="False" />
              </lzc:fields>
            </lzc:object-ref>
          </lzc:method-effects>
        </lzc:method>
        <lzc:method name="Update" object-name="Update" db-name="InstitutionUpdate" methodtype="Update" filename="InstitutionUpdate" return-result="False">
          <lzc:method-params>
            <lzc:method-param name="Id" dbname="Id" type="Int" required="True" direction="in" />
            <lzc:method-param name="Customer" dbname="CustomerId" type="Int" required="False" direction="in" />
            <lzc:method-param name="From" dbname="From" type="DateTime" required="False" direction="in" />
            <lzc:method-param name="To" dbname="To" type="DateTime" required="False" direction="in" />
            <lzc:method-param name="Name" dbname="Name" type="Varchar" size="50" required="True" direction="in" />
            <lzc:method-param name="Address" dbname="Address" type="Varchar" size="50" required="False" direction="in" />
            <lzc:method-param name="City" dbname="City" type="Varchar" size="50" required="False" direction="in" />
            <lzc:method-param name="State" dbname="StateId" type="Int" required="False" direction="in" />
            <lzc:method-param name="Country" dbname="CountryId" type="Int" required="False" direction="in" />
            <lzc:method-param name="ZipCode" dbname="ZipCode" type="Varchar" size="10" required="False" direction="in" />
            <lzc:method-param name="Email" dbname="Email" type="Varchar" size="255" required="False" direction="in" />
          </lzc:method-params>
          <lzc:method-effects>
            <lzc:object-ref name="Institution" effecttype="Update" ref="Institution" alias="Institution" pkfield="Id" fkfield="Id">
              <lzc:method-filters>
                <lzc:method-filter field="Id" param="Id" />
              </lzc:method-filters>
              <lzc:fields>
                <lzc:method-effect field="Customer" type="Int" dbtype="Int" dbname="CustomerId" param="Customer" autogenerate="False" />
                <lzc:method-effect field="From" type="DateTime" dbtype="DateTime" dbname="From" param="From" autogenerate="False" />
                <lzc:method-effect field="To" type="DateTime" dbtype="DateTime" dbname="To" param="To" autogenerate="False" />
                <lzc:method-effect field="Name" type="Varchar" dbtype="Varchar" dbname="Name" param="Name" autogenerate="False" />
                <lzc:method-effect field="Address" type="Varchar" dbtype="Varchar" dbname="Address" param="Address" autogenerate="False" />
                <lzc:method-effect field="City" type="Varchar" dbtype="Varchar" dbname="City" param="City" autogenerate="False" />
                <lzc:method-effect field="State" type="Int" dbtype="Int" dbname="StateId" param="State" autogenerate="False" />
                <lzc:method-effect field="Country" type="Int" dbtype="Int" dbname="CountryId" param="Country" autogenerate="False" />
                <lzc:method-effect field="ZipCode" type="Varchar" dbtype="Varchar" dbname="ZipCode" param="ZipCode" autogenerate="False" />
                <lzc:method-effect field="Email" type="Varchar" dbtype="Varchar" dbname="Email" param="Email" autogenerate="False" />
              </lzc:fields>
            </lzc:object-ref>
          </lzc:method-effects>
        </lzc:method>
        <lzc:method name="Get" object-name="Get" db-name="InstitutionGet" methodtype="Get" filename="InstitutionGet" return-result="True">
          <lzc:method-params>
            <lzc:method-param name="Id" dbname="Id" type="Int" required="True" direction="in" />
          </lzc:method-params>
          <lzc:method-filters>
            <lzc:method-filter field="Id" param="Id" />
          </lzc:method-filters>
          <lzc:method-results>
            <lzc:object-ref name="Institution" ref="Institution" alias="Institution" pkfield="Id" fkfield="Id" required="False">
              <lzc:fields>
                <lzc:method-result field="Id" alias="id" type="Int" dbname="Id" />
                <lzc:method-result field="Customer" alias="customer" type="Int" dbname="CustomerId" />
                <lzc:method-result field="From" alias="from" type="DateTime" dbname="From" />
                <lzc:method-result field="To" alias="to" type="DateTime" dbname="To" />
                <lzc:method-result field="Name" alias="name" type="Varchar" dbname="Name" size="50" />
                <lzc:method-result field="Address" alias="address" type="Varchar" dbname="Address" size="50" />
                <lzc:method-result field="City" alias="city" type="Varchar" dbname="City" size="50" />
                <lzc:method-result field="State" alias="state" type="Int" dbname="StateId" />
                <lzc:method-result field="Country" alias="country" type="Int" dbname="CountryId" />
                <lzc:method-result field="ZipCode" alias="zipcode" type="Varchar" dbname="ZipCode" size="10" />
                <lzc:method-result field="Email" alias="email" type="Varchar" dbname="Email" size="255" />
              </lzc:fields>
            </lzc:object-ref>
          </lzc:method-results>
        </lzc:method>
        <lzc:method name="List" object-name="List" db-name="InstitutionListByCustomer" methodtype="Custom" filename="InstitutionListByCustomer" return-result="True" />
      </lzc:methods>
    </lzc:table>
    <lzc:table name="Reference" alias="Reference" filename="Reference" namespace="ASTD.CIPortal" friendly-name="Reference" logical-name="Reference">
      <lzc:fields>
        <lzc:field name="Id" alias="id" autogenerate="True" type="Identity" friendly-name="Id" readonly="False" required="True" tableonly="False" logical-name="Id" dbname="Id" dbtype="Int">
          <lzc:indexes>
            <lzc:index name="PK_Reference" type="Primary" constraintname="PK_Reference_Id" cascade-delete="False" />
          </lzc:indexes>
        </lzc:field>
        <lzc:field name="Customer" alias="customer" autogenerate="False" type="Int" friendly-name="Customer" readonly="False" required="False" tableonly="False" logical-name="Customer" dbname="CustomerId" dbtype="Int">
          <lzc:indexes>
            <lzc:index name="IDX_Reference_Customer" alias="customer" accessor="Customer" object="Customer" type="Foreign" constraintname="FK_Reference_Customer" cascade-delete="False" />
          </lzc:indexes>
        </lzc:field>
        <lzc:field name="Name" alias="name" autogenerate="False" type="Varchar" friendly-name="Name" readonly="False" required="False" size="50" tableonly="False" logical-name="Name" dbname="Name" dbtype="Varchar" />
        <lzc:field name="Title" alias="title" autogenerate="False" type="Varchar" friendly-name="Title" readonly="False" required="False" size="50" tableonly="False" logical-name="Title" dbname="Title" dbtype="Varchar" />
        <lzc:field name="Telephone" alias="telephone" autogenerate="False" type="Varchar" friendly-name="Telephone" readonly="False" required="False" size="20" tableonly="False" logical-name="Telephone" dbname="Telephone" dbtype="Varchar" />
        <lzc:field name="Email" alias="email" autogenerate="False" type="Varchar" friendly-name="Email" readonly="False" required="False" size="255" tableonly="False" logical-name="Email" dbname="Email" dbtype="Varchar" />
      </lzc:fields>
      <lzc:methods>
        <lzc:method name="Create" object-name="Create" db-name="ReferenceCreate" methodtype="Create" filename="ReferenceCreate" return-result="False">
          <lzc:method-params>
            <lzc:method-param name="Id" dbname="Id" type="Int" required="True" direction="out" />
            <lzc:method-param name="Customer" dbname="CustomerId" type="Int" required="False" direction="in" />
            <lzc:method-param name="Name" dbname="Name" type="Varchar" size="50" required="False" direction="in" />
            <lzc:method-param name="Title" dbname="Title" type="Varchar" size="50" required="False" direction="in" />
            <lzc:method-param name="Telephone" dbname="Telephone" type="Varchar" size="20" required="False" direction="in" />
            <lzc:method-param name="Email" dbname="Email" type="Varchar" size="255" required="False" direction="in" />
          </lzc:method-params>
          <lzc:method-effects>
            <lzc:object-ref name="Reference" effecttype="Create" ref="Reference" alias="Reference" pkfield="Id" fkfield="Id">
              <lzc:fields>
                <lzc:method-effect field="Id" type="Identity" dbtype="Int" dbname="Id" param="Id" autogenerate="True" />
                <lzc:method-effect field="Customer" type="Int" dbtype="Int" dbname="CustomerId" param="Customer" autogenerate="False" />
                <lzc:method-effect field="Name" type="Varchar" dbtype="Varchar" dbname="Name" param="Name" autogenerate="False" />
                <lzc:method-effect field="Title" type="Varchar" dbtype="Varchar" dbname="Title" param="Title" autogenerate="False" />
                <lzc:method-effect field="Telephone" type="Varchar" dbtype="Varchar" dbname="Telephone" param="Telephone" autogenerate="False" />
                <lzc:method-effect field="Email" type="Varchar" dbtype="Varchar" dbname="Email" param="Email" autogenerate="False" />
              </lzc:fields>
            </lzc:object-ref>
          </lzc:method-effects>
        </lzc:method>
        <lzc:method name="Update" object-name="Update" db-name="ReferenceUpdate" methodtype="Update" filename="ReferenceUpdate" return-result="False">
          <lzc:method-params>
            <lzc:method-param name="Id" dbname="Id" type="Int" required="True" direction="in" />
            <lzc:method-param name="Customer" dbname="CustomerId" type="Int" required="False" direction="in" />
            <lzc:method-param name="Name" dbname="Name" type="Varchar" size="50" required="False" direction="in" />
            <lzc:method-param name="Title" dbname="Title" type="Varchar" size="50" required="False" direction="in" />
            <lzc:method-param name="Telephone" dbname="Telephone" type="Varchar" size="20" required="False" direction="in" />
            <lzc:method-param name="Email" dbname="Email" type="Varchar" size="255" required="False" direction="in" />
          </lzc:method-params>
          <lzc:method-effects>
            <lzc:object-ref name="Reference" effecttype="Update" ref="Reference" alias="Reference" pkfield="Id" fkfield="Id">
              <lzc:method-filters>
                <lzc:method-filter field="Id" param="Id" />
              </lzc:method-filters>
              <lzc:fields>
                <lzc:method-effect field="Customer" type="Int" dbtype="Int" dbname="CustomerId" param="Customer" autogenerate="False" />
                <lzc:method-effect field="Name" type="Varchar" dbtype="Varchar" dbname="Name" param="Name" autogenerate="False" />
                <lzc:method-effect field="Title" type="Varchar" dbtype="Varchar" dbname="Title" param="Title" autogenerate="False" />
                <lzc:method-effect field="Telephone" type="Varchar" dbtype="Varchar" dbname="Telephone" param="Telephone" autogenerate="False" />
                <lzc:method-effect field="Email" type="Varchar" dbtype="Varchar" dbname="Email" param="Email" autogenerate="False" />
              </lzc:fields>
            </lzc:object-ref>
          </lzc:method-effects>
        </lzc:method>
        <lzc:method name="Get" object-name="Get" db-name="ReferenceGet" methodtype="Get" filename="ReferenceGet" return-result="True">
          <lzc:method-params>
            <lzc:method-param name="Id" dbname="Id" type="Int" required="True" direction="in" />
          </lzc:method-params>
          <lzc:method-filters>
            <lzc:method-filter field="Id" param="Id" />
          </lzc:method-filters>
          <lzc:method-results>
            <lzc:object-ref name="Reference" ref="Reference" alias="Reference" pkfield="Id" fkfield="Id" required="False">
              <lzc:fields>
                <lzc:method-result field="Id" alias="id" type="Int" dbname="Id" />
                <lzc:method-result field="Customer" alias="customer" type="Int" dbname="CustomerId" />
                <lzc:method-result field="Name" alias="name" type="Varchar" dbname="Name" size="50" />
                <lzc:method-result field="Title" alias="title" type="Varchar" dbname="Title" size="50" />
                <lzc:method-result field="Telephone" alias="telephone" type="Varchar" dbname="Telephone" size="20" />
                <lzc:method-result field="Email" alias="email" type="Varchar" dbname="Email" size="255" />
              </lzc:fields>
            </lzc:object-ref>
          </lzc:method-results>
        </lzc:method>
        <lzc:method name="List" object-name="List" db-name="ReferenceListByCustomer" methodtype="List" filename="ReferenceListByCustomer" return-result="True">
          <lzc:method-params>
            <lzc:method-param name="Customer" dbname="CustomerId" type="Int" required="True" direction="in" />
          </lzc:method-params>
          <lzc:method-filters>
            <lzc:method-filter field="Customer" param="Customer" />
          </lzc:method-filters>
          <lzc:method-results>
            <lzc:object-ref name="Reference" ref="Reference" alias="Reference" fkfield="Id" required="True">
              <lzc:fields>
                <lzc:method-result field="Id" alias="Id" type="Int" dbname="Id" />
                <lzc:method-result field="Customer" alias="CustomerId" type="Int" dbname="CustomerId" />
                <lzc:method-result field="Name" alias="Name" type="Varchar" dbname="Name" size="50" />
                <lzc:method-result field="Title" alias="Title" type="Varchar" dbname="Title" size="50" />
                <lzc:method-result field="Telephone" alias="Telephone" type="Varchar" dbname="Telephone" size="20" />
                <lzc:method-result field="Email" alias="Email" type="Varchar" dbname="Email" size="255" />
              </lzc:fields>
            </lzc:object-ref>
          </lzc:method-results>
        </lzc:method>
      </lzc:methods>
    </lzc:table>
  </lzc:tables>
</lzc:project>